Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Yuhka
New Contributor III

Filtering records using variable

 

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.

キャプチャ.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

Is it possible to filtering result like this?

Thank you for your support.

 

 

 

1 Solution

Accepted Solutions
jyothish8807
Honored Contributor II

Re: Filtering records using variable

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)

Best Regards,
KC
3 Replies
MVP
MVP

Re: Filtering records using variable

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
Honored Contributor II

Re: Filtering records using variable

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)

Best Regards,
KC
Yuhka
New Contributor III

Re: Filtering records using variable

Thank you for your support, guys.

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