Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

complex Multi-Value filtering on data

Hi Experts,

I have data as shown below

MonthIDDriverIncident Flag
Feb 191E1
Feb 191B0
Feb 191C0
Feb 192B1
Feb 192C0
Feb 193E0
Feb 193C1
Feb 194E0
Feb 194B1
Feb 195E1
Feb 196B1
Feb 196C1

 

I want to filter the data so that I see all the ID's that involve 'E' Driver and has the Incident Flag as 1.

The result from the above data should be

MonthIncidents
Feb-194

 

I appreciate your help on this. Thanks in advance.

Labels (1)
5 Replies
Highlighted
Specialist II
Specialist II

I do not see Month Field in the input Data

Highlighted
Creator II
Creator II

You can filter data in script,

Like

load

from tablename where  Driver='E' and Incident Flag='1'

or expression level also you can handle this

thanks

Highlighted
Creator III
Creator III

Sorry, I have updated my data table now.
Highlighted
Creator III
Creator III

Thank you for your reply.

Could you please help me providing the expression formula to handle this.

If you could have sample dashboard created that would be great. Thanks in advance.

Highlighted
Creator III
Creator III

Thank you for your reply.

Could you please help me providing the expression formula to handle this.

If you could have sample dashboard created that would be great. Thanks in advance.