Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Set Analysis to show field values based on condition

I want to show Field Values based on Conditions/Filters. I can use 'if', but the filters have to be manually selected in order for the values to be filtered. I need something like Set Analysis that doesn't change with other filters but show the values defined within the Expression.

if(FieldA='A', FieldB='B', FieldC)

In this case, the user needs to select 'A' in FieldA and 'B' in FieldB. I need the table to show only those values in FieldC that satisfies FieldA=A and FieldB=B all the time; something like Set Analysis but without Numeric Operators like Sum or Count?

11 Replies
Master II
Master II


Only({1<FieldA={'A'},FieldB={'B'}>} FieldC)

If you have a data set someone can help easily...

1 <<< in Set Analysis would ignore any selections made in filter hence Field A or Field B would be static.

View solution in original post

Creator II
Creator II

Perfect. The '1' identifier is all I was looking for. This disregards any other values except for those mentioned in the Expression. Thank you so much