Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
May be like this
if(isnull(GetCurrentSelections()),'N/A',YourRelevantMesureHere)
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.