topic Re: Getselectedcount for filtered list box in QlikView

Getselectedcount for filtered list box

jeevays7 — Tue, 05 Jun 2018 09:47:41 GMT

Hi,

I have a list box in qlik sense using $Table field and i have applied a filter condition in this list box.

Ex: IF($Table<>'Table1',$Table)

when i select a value in the above list box, the getselectedcount($Table) fucntion is not working correctly and it is always showing "0".

How to fix it?

Re: Getselectedcount for filtered list box

petter — Tue, 05 Jun 2018 10:14:34 GMT

Seems to work fine for me:

I used as basis for the Field the Expression: If( $Table <> 'Sales' , $Table )

Re: Getselectedcount for filtered list box

jeevays7 — Tue, 05 Jun 2018 10:36:50 GMT

For me it is not working Petter.

i am also using the same conditions.

if( $Table <>'CAPITAL_FLOW', $Table)

GetSelectedCount($Table)

Re: Getselectedcount for filtered list box

jeevays7 — Tue, 05 Jun 2018 10:55:34 GMT

Please find my attachment (2nd sheet) and suggest me !

Re: Getselectedcount for filtered list box

sunny_talwar — Tue, 05 Jun 2018 11:18:54 GMT

Try this as a filter box expression

=Aggr(Only({1<$Table -= {'DATA'}>} $Table), $Table)

Re: Getselectedcount for filtered list box

jeevays7 — Tue, 05 Jun 2018 11:29:45 GMT

Thank you very much sunny.

It is working fine now.

Re: Getselectedcount for filtered list box

sunny_talwar — Tue, 05 Jun 2018 11:30:46 GMT

Awesome, I am glad we were able to help

Re: Getselectedcount for filtered list box

jeevays7 — Tue, 05 Jun 2018 11:31:56 GMT

But i don't know why it happening like this.

Can you explain me? why we need to use aggr() here?

Re: Getselectedcount for filtered list box

sunny_talwar — Tue, 05 Jun 2018 11:42:06 GMT

I am not entirely sure why, but Qlik Sense is unique in a way it works with calculated dimension using if statement... it is as if it creates a new field of it's own which can't really be used with some of the functions such as GetFieldCount() of GetFieldSelections() etc because it is not using the exact field and you cannot really use calculated dimensions in those functions.

Aggr behaves a little different... why? I am not sure... but it can pick the selection directly in the field... so that is why it works.

Re: Getselectedcount for filtered list box

jeevays7 — Tue, 05 Jun 2018 11:45:19 GMT

Okay, Thanks sunny.

Re: Getselectedcount for filtered list box

petter — Tue, 05 Jun 2018 11:57:56 GMT

You posted this in a QlikView Application Development so I tested it in QlikView not Qlik Sense. I overlooked what you wrote in your question referring to "qlik sense" ... Important that you post your questions in the right thread/group...