Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

josielaidlaw
New 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

Re: Adding multiple filters in a graph

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

Re: Adding multiple filters in a graph

You need to add two more expressions 

 

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

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

Capture.PNG

josielaidlaw
New Contributor II

Re: Adding multiple filters in a graph

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.

Re: Adding multiple filters in a graph

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