topic Filtering records using variable in QlikView

Filtering records using variable

Yuhka — Sat, 16 Nov 2024 03:55:02 GMT

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.

Re: Filtering records using variable

tresB — Tue, 09 Apr 2019 08:01:30 GMT

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.

Re: Filtering records using variable

jyothish8807 — Tue, 09 Apr 2019 09:32:46 GMT

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)

Re: Filtering records using variable

Yuhka — Wed, 10 Apr 2019 00:46:34 GMT

Thank you for your support, guys.

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