Dynamic woking of flag on expression based on

[Anonymous]

We have a table with entries name, company, event, event attended, flag_attended,

Name	company	event	event attended	flag attended	year
A	xc	ra	yes	1	2016
b	xb	e	no	0	2016
A	bc	t	no	0	2017
c	xb	w	yes	1	2017
A	xc	ras	no	0	2017

we want to create a flag which will identify set of individuals who never attended &

example: for A of company XC when we select year as 2016 then flag never attended is 0, for 2017 it should 1,

when nothing is selected it should be 0.

How to write it in QlikView expression so that the value of the flag is determined on runtime dynamically when the user select year filter??

[m_woolf]

What's the difference between Event Attended and Flag Attended?

[antoniotiman]

Try this

Aggr(If(Min([flag attended]) = 0,1,0),Name,company)