IF statement help

[#1]

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

The feild names which are being used are :

• SLA_Failed
• Duration
• Incident - Number

The code that needs to be generated for qlikview is:

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

[adhudson · Accepted solution]

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

[#3]

Thank you that was extermely helpful