topic Re: if conditions in QlikView

if conditions

himabinduch — Fri, 18 Sep 2015 06:26:30 GMT

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

Re: if conditions

gautik92 — Fri, 18 Sep 2015 10:14:30 GMT

can yu share sample data

my guess it could solve

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

Re: if conditions

pokassov — Fri, 18 Sep 2015 10:15:32 GMT

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

Re: if conditions

himabinduch — Fri, 18 Sep 2015 11:17:15 GMT

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