GnuCash › GnuCash - User

"Excel Type" of filtering

Classic

List

Threaded

6 messages Options

richdthomas

"Excel Type" of filtering

Hi,

Does anybody know if it is possible to apply a filter on an account, in a
similar way that Microsoft Excel does?

I'd like to quickly have a view that shows the uncleared transactions and
selecting a filter that only shows transactions whose "R" is "n" would be a
good way of doing this.

Thanks in advance,

Richard.
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Geert Janssens

Re: "Excel Type" of filtering

View -> Filter by...
Then switch to the Status tab.

That should be what you are looking for.

Geert

On 17-08-12 22:23, Richard Thomas wrote:

> Hi,
>
> Does anybody know if it is possible to apply a filter on an account, in a
> similar way that Microsoft Excel does?
>
> I'd like to quickly have a view that shows the uncleared transactions and
> selecting a filter that only shows transactions whose "R" is "n" would be a
> good way of doing this.
>
> Thanks in advance,
>
> Richard.
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

richdthomas

Re: "Excel Type" of filtering

On 17 August 2012 21:58, Richard Thomas <[hidden email]> wrote:

> Hi Geert,
>
> Thank you for that advice.
>
> Please could you let me know how I get to the Status tab.
>
> Thanks,
>
> Richard.
>
>
>
> On 17 August 2012 21:33, Geert Janssens <[hidden email]> wrote:
>
>> View -> Filter by...
>> Then switch to the Status tab.
>>
>> That should be what you are looking for.
>>
>> Geert
>>
>>
>> On 17-08-12 22:23, Richard Thomas wrote:
>>
>>> Hi,
>>>
>>> Does anybody know if it is possible to apply a filter on an account, in a
>>> similar way that Microsoft Excel does?
>>>
>>> I'd like to quickly have a view that shows the uncleared transactions and
>>> selecting a filter that only shows transactions whose "R" is "n" would
>>> be a
>>> good way of doing this.
>>>
>>> Thanks in advance,
>>>
>>> Richard.
>>> ______________________________**_________________
>>> gnucash-user mailing list
>>> [hidden email]
>>> https://lists.gnucash.org/**mailman/listinfo/gnucash-user<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>> ______________________________**_________________
>> gnucash-user mailing list
>> [hidden email]
>> https://lists.gnucash.org/**mailman/listinfo/gnucash-user<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>

Colin Law-4

Re: "Excel Type" of filtering

On 17 August 2012 21:59, Richard Thomas <[hidden email]> wrote:
> On 17 August 2012 21:58, Richard Thomas <[hidden email]> wrote:
>
>> Hi Geert,
>>
>> Thank you for that advice.
>>
>> Please could you let me know how I get to the Status tab.

Select View then Filter By and then click where it says Status.

Colin

>>
>> Thanks,
>>
>> Richard.
>>
>>
>>
>> On 17 August 2012 21:33, Geert Janssens <[hidden email]> wrote:
>>
>>> View -> Filter by...
>>> Then switch to the Status tab.
>>>
>>> That should be what you are looking for.
>>>
>>> Geert
>>>
>>>
>>> On 17-08-12 22:23, Richard Thomas wrote:
>>>
>>>> Hi,
>>>>
>>>> Does anybody know if it is possible to apply a filter on an account, in a
>>>> similar way that Microsoft Excel does?
>>>>
>>>> I'd like to quickly have a view that shows the uncleared transactions and
>>>> selecting a filter that only shows transactions whose "R" is "n" would
>>>> be a
>>>> good way of doing this.
>>>>
>>>> Thanks in advance,
>>>>
>>>> Richard.
>>>> ______________________________**_________________
>>>> gnucash-user mailing list
>>>> [hidden email]
>>>> https://lists.gnucash.org/**mailman/listinfo/gnucash-user<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>>
>>> ______________________________**_________________
>>> gnucash-user mailing list
>>> [hidden email]
>>> https://lists.gnucash.org/**mailman/listinfo/gnucash-user<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Geert Janssens

Re: "Excel Type" of filtering

In reply to this post by Geert Janssens

Please send your replies to the list. You can do this by using the reply
to all or reply to list feature of your mail client.

As to your question, maybe my reply was too terse:
View -> Filter by... opens a small window with two tabs, named "Date"
and "Status". To go to the Status tab, well, you click on the tab named
"Status". It may be called differently if you are not using GnuCash in
the English language.

Is that more clear ?

Geert

On 17-08-12 22:58, Richard Thomas wrote:

> Hi Geert,
>
> Thank you for that advice.
>
> Please could you let me know how I get to the Status tab.
>
> Thanks,
>
> Richard.
>
>
> On 17 August 2012 21:33, Geert Janssens <[hidden email]
> <mailto:[hidden email]>> wrote:
>
> View -> Filter by...
> Then switch to the Status tab.
>
> That should be what you are looking for.
>
> Geert
>
>
> On 17-08-12 22:23, Richard Thomas wrote:
>
> Hi,
>
> Does anybody know if it is possible to apply a filter on an
> account, in a
> similar way that Microsoft Excel does?
>
> I'd like to quickly have a view that shows the uncleared
> transactions and
> selecting a filter that only shows transactions whose "R" is
> "n" would be a
> good way of doing this.
>
> Thanks in advance,
>
> Richard.
> _______________________________________________
> gnucash-user mailing list
> [hidden email] <mailto:[hidden email]>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
> _______________________________________________
> gnucash-user mailing list
> [hidden email] <mailto:[hidden email]>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

richdthomas

Re: "Excel Type" of filtering

In reply to this post by Colin Law-4

Hi,

Oh, as easy as that :)

Thank you very much for this, just what I was looking for.

Thanks again,

Richard.

On 17 August 2012 22:12, Colin Law <[hidden email]> wrote:

> On 17 August 2012 21:59, Richard Thomas <[hidden email]> wrote:
> > On 17 August 2012 21:58, Richard Thomas <[hidden email]> wrote:
> >
> >> Hi Geert,
> >>
> >> Thank you for that advice.
> >>
> >> Please could you let me know how I get to the Status tab.
>
> Select View then Filter By and then click where it says Status.
>
> Colin
>
> >>
> >> Thanks,
> >>
> >> Richard.
> >>
> >>
> >>
> >> On 17 August 2012 21:33, Geert Janssens <[hidden email]>
> wrote:
> >>
> >>> View -> Filter by...
> >>> Then switch to the Status tab.
> >>>
> >>> That should be what you are looking for.
> >>>
> >>> Geert
> >>>
> >>>
> >>> On 17-08-12 22:23, Richard Thomas wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> Does anybody know if it is possible to apply a filter on an account,
> in a
> >>>> similar way that Microsoft Excel does?
> >>>>
> >>>> I'd like to quickly have a view that shows the uncleared transactions
> and
> >>>> selecting a filter that only shows transactions whose "R" is "n" would
> >>>> be a
> >>>> good way of doing this.
> >>>>
> >>>> Thanks in advance,
> >>>>
> >>>> Richard.
> >>>> ______________________________**_________________
> >>>> gnucash-user mailing list
> >>>> [hidden email]
> >>>> https://lists.gnucash.org/**mailman/listinfo/gnucash-user<
> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >>>> -----
> >>>> Please remember to CC this list on all your replies.
> >>>> You can do this by using Reply-To-List or Reply-All.
> >>>>
> >>>
> >>> ______________________________**_________________
> >>> gnucash-user mailing list
> >>> [hidden email]
> >>> https://lists.gnucash.org/**mailman/listinfo/gnucash-user<
> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>>
> >>
> >>
> > _______________________________________________
> > gnucash-user mailing list
> > [hidden email]
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>