Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel77
Creator
Creator

Create a button to filter in If statement

Hi,

I have a situation where null values are created by another dimension, not true null. I can give these a value by using a count, the return will be 0, then i use if the count = 0 give a value. This is now selectable in the table. Great!

if(aggr(count([Standard Name]),[Production Facility])=0,'No Standards')

 

However, i now need a button to filter these values and i am struggling to get this. I have tried a few thing with non working. Like using Select values matching search criteria and the value 'No Standards' But i guess this is not a real value!

Does anyone know how i can use a button to filter the created 'No Standards' in the field Standard Name?

Thank you in advance.

 

Daniel

Labels (2)
1 Solution

Accepted Solutions
Syed_M0
Partner - Contributor III
Partner - Contributor III

You can create the exact condition in the back end and use it for your use case.

example:

          Table:

          Load *,

          If([Standard Count] =0,'No Standards','Standard') as Flag;

          Load [Production Facility],

          count([Standard Name]) as [Standard Count]

          Resident <Your Respective Table >;

Use this Flag in the button

 

View solution in original post

4 Replies
Anil_Babu_Samineni

Perhaps create a bookmark and use that?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Daniel77
Creator
Creator
Author

Good thinking, this may be my only option! Thank you for the thought.

Daniel

Syed_M0
Partner - Contributor III
Partner - Contributor III

You can create the exact condition in the back end and use it for your use case.

example:

          Table:

          Load *,

          If([Standard Count] =0,'No Standards','Standard') as Flag;

          Load [Production Facility],

          count([Standard Name]) as [Standard Count]

          Resident <Your Respective Table >;

Use this Flag in the button

 

Anil_Babu_Samineni

If you got what you need, Please don't forget to close the thread. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful