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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Cameron94
Partner - Contributor III
Partner - Contributor III

How to show different value when no filter has been selected?

Within Qlik sense, is it possible to create a if statement for when no filter is selected? 

An example: When no filter is selected, the data shows figures that are not related to the data required.

I need the data to show N/A or 0.00 when no filter has been selected.

 

Labels (3)
2 Replies
brunobertels
Master
Master

Hi 

May be like this 

if(isnull(GetCurrentSelections()),'N/A',YourRelevantMesureHere)

Cameron94
Partner - Contributor III
Partner - Contributor III
Author

Cameron94_0-1657553830449.png

 

For example, this 179.781.63 figure is incorrect. I need it to show 0 or a similar result if this height of figure is reached. The '3.00' is displayed correctly.