topic Re: if condition in QlikView

if condition

mshailaja — Wed, 25 Nov 2020 16:16:04 GMT

i have table called status in which Incidents status wil bee updated as

RE,CL,OP,ACK,SUSP

The user wants only ACK,SUSP,OP as Raised Incidents

and RE as Resolved Incidents.

I have to show the incidents for the particular group in the Graph as Raised Incidents and resolved Incidents

Can anyone help me to write the if condition in script , so that i can get the graph like below

ahaahaaha — Fri, 31 Mar 2017 11:44:20 GMT

Hi,

May be like this

Dimension: Incidents

Expression: Count({<Incidents={'ACK,SUSP,OP'}>}Incidents)

Regards,

Andrey

dsharmaqv — Fri, 31 Mar 2017 11:50:11 GMT

use 2 expression in chart

Raised

Count({<Incidents={'ACK,SUSP,OP'}>}Incidents)

Resolved

Count({<Incidents={'RE'}>}Incidents)

avinashelite — Fri, 31 Mar 2017 11:55:51 GMT

You could create new field in the script like this

if( status='ACK' or status='SUSP' or status='OP','Raised Incidents','Resolved Incidents') as New_Status

add the New status as the dimension

and expression

Count(Incidents)

rahulpawarb — Fri, 31 Mar 2017 11:59:59 GMT

Hello Sailaja,

Please use below sample expressions:

     If(Match(Status, 'ACK', 'SUSP', 'OP') > 0, 1, 0) AS Received,
     If(Status='RE', 1, 0) AS Resolved

Refer attached sample application.

Regards!
Rahul