Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
josielaidlaw
Contributor II
Contributor II

Adding multiple filters in a graph

Hi all,

I am still new to Qlikview, and I am trying to create a graph with some filtered data. Ideally, I would like to filter one column, and then filter another based on the results of that one, and finally display that in a graph, over the fiscal months. I have no issues with what I have so far, however, I cannot figure out the syntax for more than one filter. I am using

Count({$<Grund={'Betriebsunfall'}>}Grund)

Which searches the column Grund for values matching Betriebsunfall. Then, I would like to search the column next to it, Firma, for values matching and not matching SMO.

I have attached a sample file. I hope this was a clear explanation.

Thanks, 
Josie

1 Solution

Accepted Solutions
sunny_talwar

May be these

Search for SMO in Firma

Count({$<Grund = {'Betriebsunfall'}, Firma = {'SMO'}>} Grund)

Search for Non SMO in Firma

Count({$<Grund = {'Betriebsunfall'}>} Grund) -
Count({$<Grund = {'Betriebsunfall'}, Firma = {'SMO'}>} Grund)

View solution in original post

3 Replies
shiveshsingh
Master
Master

You need to add two more expressions 

 

1: Count({$<Firma={'SMO'}>}Firma)

2: Count({$<Firma-={'SMO'}>}Firma

Capture.PNG

josielaidlaw
Contributor II
Contributor II
Author

I'm not sure I understand - this appears to just count the instances where SMO appears and doesn't appear, disregarding the filter in the Grund column.

I need it to filter the Firma column, based on the filter applied in the Grund column.

sunny_talwar

May be these

Search for SMO in Firma

Count({$<Grund = {'Betriebsunfall'}, Firma = {'SMO'}>} Grund)

Search for Non SMO in Firma

Count({$<Grund = {'Betriebsunfall'}>} Grund) -
Count({$<Grund = {'Betriebsunfall'}, Firma = {'SMO'}>} Grund)

View solution in original post