if conditions

[himabinduch]

Hi Friends,

i am new to QLIK VIEW and in my dashboard i have fields (incident numbers and status,sla violation). and  in incident number number i have incidents number status field contains status of that  incidents, sla violation contains "yes" and "no" options

Now i want to show incident numbers which contains sla violation is yes and status should be open

Can some one help me out this 

[gautik92 · Accepted solution]

can yu share sample data

my guess it could solve

count({$<SlaViolation={'Yes'},Status={'Open'}>}incident numbers)

[pokassov]

count({$<[sla violation]={'yes'}, status={'open'}>} [incident number])

[himabinduch]

Hi Gowtham,

it is working and i have one more doubt

i.e i want only open SlaViolation incident numbers will it possible through if condition or we have to wright Set analysis for this