Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF statement help

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)) , )

1 Solution

Accepted Solutions
adhudson
Creator II
Creator II

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

View solution in original post

2 Replies
adhudson
Creator II
Creator II

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

Not applicable
Author

Thank you that was extermely helpful