Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Add Criteria in visual opposed to using a Filter

Hi, 

I have a line chart where by I need to see the results based on a selection. I could use the filter but I want this visual to remain static and not be dependent on a filter selection. 

Dimensions - Group

Months_to_convert

Dimension - Line

=IF(MATCH(Price_Band,'Low','High'),Price_Band)

Measure

Aggr(RangeSum(Above(Count(Count_TY), 0, RowNo())),Price_Band,(Months_to_convert,(Numeric,Ascending)))

/
Aggr(count(TOTAL <Price_Band> Count_TY),Price_Band,(Months_to_convert,(Numeric,Ascending)))

 

What I want to include is to show this where Category_In = 'PAL'. I don't need to see this on my line chart, just need to only show results that are Category_In = 'PAL'

Any idea how to include this please?

1 Reply
Highlighted
Specialist II
Specialist II

You can use Set Analysis 

for example Count({<Category_In={'PAL'}>}Count_TY),