Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Filtering based on value within a variable

Hi all,

Wondering if anyone has any ideas - I want to have a dimension (say field_a) within a straight table, but I only want to display the value of Field_a that matches the value in a variable x.

So for example, say we have field_A with the unique values as:

field_a
-------
a
b
c
d
e1
e2
etc.

Variable x has value c, then I only want the straight table to show the value c.

Guess I can use set analysis to solve this - within the dimension somehow, but not quite sure how. Any suggestions?

Regards,

Revlin

1 Solution

Accepted Solutions
jagannalla
Valued Contributor III

Re: Filtering based on value within a variable

Click on AddCalculationDimension and use this code there

=If(Field_A='$(Variable)',Field_A)

Now click on OK & check Supprss when value is null.

Hope it helps you

Cheers!

Jagan

4 Replies
Not applicable

Re: Filtering based on value within a variable

try this:

jagannalla
Valued Contributor III

Re: Filtering based on value within a variable

Click on AddCalculationDimension and use this code there

=If(Field_A='$(Variable)',Field_A)

Now click on OK & check Supprss when value is null.

Hope it helps you

Cheers!

Jagan

Not applicable

Re: Filtering based on value within a variable

Hi - sorry I only have the free version of Qlikview so cannot open any other files.

Is it a dimention expression you could paste in here?

Not applicable

Re: Filtering based on value within a variable

Thank you Jagan!

Community Browser