topic Re: Count Function - only look at selection? in QlikView

Count Function - only look at selection?

Tue, 01 Jul 2014 08:51:16 GMT

Hi,

From what I understand, =count({$<Leg={"Allocation"}>}[Trade ID]) should only be looking at the current selection, right? However, adding a Leg listbox in and filtering out all Allocation trades, it still shows 1.

I honestly can't share any data and I would only prepare an extract if really required - have ever seen this sort of problem though and are there some easy things to look at first maybe?

Thanks!

Re: Count Function - only look at selection?

MK_QSL — Tue, 01 Jul 2014 08:52:38 GMT

=count({$<Leg={"Allocation"}>}DISTINCT [Trade ID])

What is your requirement? Not clear from your question.

Re: Count Function - only look at selection?

hic — Tue, 01 Jul 2014 08:53:44 GMT

It does not look at the current selection. It takes the current selection, and modifies this according to your set expression. So, in your case, it doesn't matter what the selection in "Leg" is - it will always look at 'Allocation' only.

HIC

Re: Count Function - only look at selection?

Tue, 01 Jul 2014 09:49:30 GMT

Oh that's interesting! Thank you Henric Cronström, that changes a lot. How would I count the number of Leg=Allocation in the current selection?

Re: Count Function - only look at selection?

tresB — Tue, 01 Jul 2014 09:52:44 GMT

May be this?

=count({$<Leg={"Allocation"}>} Leg)

Re: Count Function - only look at selection?

Tue, 01 Jul 2014 09:55:50 GMT

That would still change the selection to Allocation, just counting on a different field right? So wouldn't solve it.

Re: Count Function - only look at selection?

tresB — Tue, 01 Jul 2014 09:59:41 GMT

Sorry, did not get your requirement properly. Could you elaborate a bit more?

Re: Count Function - only look at selection?

Tue, 01 Jul 2014 10:02:56 GMT

Count how many Leg=Allocation there are in the current selection. If allocation isn't selected from a different listbox, this should obviously be 0.

Re: Count Function - only look at selection?

tresB — Tue, 01 Jul 2014 10:11:41 GMT

=count({$<Leg={"=Leg='Allocation' "}>} Leg)

Or,

Count(If(Leg='Allocation', Leg))