Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to filter dashboard with count expression through an action button

Hello,

We have a expression with count and want to know how to select it and filter on the resultant IDENTITYNUMBER.

count({<B_ISCANCELED={1}>-<IDENTITYNUMBER=P({<B_ISCANCELED={0}>})>}IDENTITYNUMBER)


We want to have a button on which we click on the count number it will filter all the IDENTITYNUMBER according to the count.


We know that it is possible through navigation extension in which we can define and ACTION.  What expression do we put in the action so that it filters the IDENTITYNUMBER.


Also please note that there are about 60 Million records in he table so we are also looking for a solution which would be optimim in performance.


Will appreciate some help.


4 Replies
Highlighted
Specialist
Specialist

Hi, Syed, maybe this expression for button action would help

='("' & Concat( {<B_ISCANCELED={1}>-<IDENTITYNUMBER=P({<B_ISCANCELED={0}>})>}IDENTITYNUMBER, '"|"') & '")'

Highlighted
Partner
Partner

Andrey,

Thanks for the response.  I was thinking about the same but due to the fact that there are total of 60million records and filtered would be atleast 6 million records then this might pose an issue on the front end through the expression?

What do you suggest on large data set?

Highlighted
Specialist
Specialist

I'm struggling here. Does it take a long time?

Highlighted
Specialist
Specialist

OK, I'm not sure, but how about this scenario?

1. Selection -> Select in field            [B_ISCANCELED]            ->  0

2. Selection -> Select Possible            [IDENTITYNUMBER]

3. Selection -> Select in field          [B_ISCANCELED]      ->  1

4. Selection -> Select Excluded    [IDENTITYNUMBER]