Qlik Community

Ask a Question

App Development

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

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sjhussain
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
andrey_krylov
Specialist
Specialist

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

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

sjhussain
Partner
Partner
Author

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?

andrey_krylov
Specialist
Specialist

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

andrey_krylov
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]