topic Re: complex Multi-Value filtering on data in QlikView

complex Multi-Value filtering on data

shyamcharan — Sat, 16 Nov 2024 04:12:44 GMT

Hi Experts,

I have data as shown below

Month	ID	Driver	Incident Flag
Feb 19	1	E	1
Feb 19	1	B	0
Feb 19	1	C	0
Feb 19	2	B	1
Feb 19	2	C	0
Feb 19	3	E	0
Feb 19	3	C	1
Feb 19	4	E	0
Feb 19	4	B	1
Feb 19	5	E	1
Feb 19	6	B	1
Feb 19	6	C	1

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

Month	Incidents
Feb-19	4

I appreciate your help on this. Thanks in advance.

Re: complex Multi-Value filtering on data

anushree1 — Tue, 12 Mar 2019 06:47:22 GMT

I do not see Month Field in the input Data

Re: complex Multi-Value filtering on data

kishorj1982 — Wed, 13 Mar 2019 13:30:49 GMT

You can filter data in script,

load

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

or expression level also you can handle this

thanks

Re: complex Multi-Value filtering on data

shyamcharan — Thu, 14 Mar 2019 04:53:24 GMT

Sorry, I have updated my data table now.

Re: complex Multi-Value filtering on data

shyamcharan — Thu, 14 Mar 2019 04:54:31 GMT

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.

Re: complex Multi-Value filtering on data

shyamcharan — Thu, 14 Mar 2019 04:55:05 GMT

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.