Discussion board where members can get started with QlikView.
Hello everuone, I'm new to qlikview.
I have a straigh table to count number, and I would like to use variable to filter recoeds as follows.
Is it possible to filtering result like this?
Thank you for your support.
Go to Solution.
You can also create a calculated dimension like this:
And keep your expression as it is. Click on suppress Null value on dimension (ref attached)
You could use expression like:
However, this would only show the other irrelevant rows as blank, if you need to filter the entire chart on this condition, you have to use similar condition for all the others expressions, and allow suppress options in presentation tab.
Thank you for your support, guys.
@jyothish8807, it is what I wanted to do! Thank you for your help!!