Filtering records using variable

[Yuhka]

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.

[tresesco]

You could use expression like: 

=if(Count(No)>=vCountNo, Count(No))

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.

[jyothish8807 · Accepted solution]

Hi Yuhka,

You can also create a calculated dimension like this:

=if(Aggr(Count(No),Code)>=vCountNo,Code)

And keep your expression as it is. Click on suppress Null value on dimension (ref attached)

[Yuhka]

Thank you for your support, guys.

@jyothish8807, it is what I wanted to do! Thank you for your help!!