topic IF statement help in QlikView

IF statement help

Tue, 24 Apr 2012 09:14:47 GMT

Hey All need write an expression within a graph to give its desired plot.

The feild names which are being used are :

The code that needs to be generated for qlikview is:

If ( SLA_Failed = 'Yes' & Duration >= 100 , Count(Distinct(Incident - Number)) , )

adhudson — Tue, 24 Apr 2012 09:26:23 GMT

Hi,

Try using the if statement inside the count function like below.

count( distinct if(SLA_Failed='Yes' and Duration >= 100, [Incident - Number]))

Hope this helps.

Regards

Andrew Hudson

Tue, 24 Apr 2012 10:00:20 GMT

Thank you that was extermely helpful