Filtering dimension based on object selection button

prathmeshb27 — Sat, 11 Nov 2023 10:57:43 GMT

Hi, I have a dimension as STATUS which includes different fields like opened, cancelled,......etc . I created one text object I see it as a button. Whenever I click button the table should show all the record including (cancelled) and again when I click button it should show all the record except (cancelled). How can I do that?

Re: Filtering dimension based on object selection button

sidhiq91 — Sun, 03 Dec 2023 04:11:21 GMT

@prathmeshb27 Please follow the below steps:

Step 1: I created a sample data in load script Editor

NoConcatenate
Temp:
Load ID, Status, Date(Date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') as Date

Inline [
ID, Status, Date
1, Opened, 03/11/2023
2, Cancelled, 04/11/2023
3, Cancelled, 05/11/2023
4, Closed, 06/11/2023
5,Re-Opened,07/11/2023
];

Step2: Create 2 straight tables one for Cancelled Status and one for other Status

To get only Cancelled Status I used the below expression:

Aggr(Only({<Status={'Cancelled'}>}Status),Status)

To get other Status I used another expression:

Aggr(Only({<Status-={'Cancelled'}>}Status),Status)

Step 3: To create a toggle button between 2 Status, follow the link below:

https://www.youtube.com/watch?v=PLlguzpVdB0

If this resolves your issue, please like and accept it as a solution.

topic Filtering dimension based on object selection button in QlikView

Filtering dimension based on object selection button

Re: Filtering dimension based on object selection button