Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)) , )
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
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
Thank you that was extermely helpful