Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Hope you can help! I'm relatively new to QlikView and am stuck. I am creating a dashboard to show techs in my office if a ticket is coming up on its SLA. I have 3 categories, Breached, Within a day and more than a day. The first and the last are working fine but the "Within a day" is giving me a hard time.
For breached im using =Count({$<SLA_Score={"<0"}>} distinct [INC Number]).
How do I say Count if greater than 0 but less than 1?
I tried =Count({$<SLA_Score={">0"}>} & {$<SLA_Score={"<1"}>} distinct [INC Number]) but that didnt work. I know i probably have the syntax wrong somewhere but have searched the forums and cant find a solution that works! Any help would greatly be appreciated!
Thanks,
Chris
Forgot to mention SLA_Score is derived from sla_due - Today()
Add both conditions to the same set specifier, like
...{$<SLA_Score={">0.0<1.0"}>}...
Count({$<SLA_Score={'>0<1'}>} distinct [INC Number])
This means you are calculating score from 2 dates. If though how come 0 and 1 part in set expression. Can you provide few values for score
Thank You! That appears to be working! Not sure why i didnt think to put the conditions into the same set.