topic Re: Greater Than and Less Than? in QlikView

Greater Than and Less Than?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Greater Than and Less Than?

Tue, 22 Aug 2017 18:08:22 GMT

Forgot to mention SLA_Score is derived from sla_due - Today()

Re: Greater Than and Less Than?

Peter_Cammaert — Tue, 22 Aug 2017 18:57:39 GMT

Add both conditions to the same set specifier, like

...{$<SLA_Score={">0.0<1.0"}>}...

Re: Greater Than and Less Than?

sasiparupudi1 — Tue, 22 Aug 2017 19:52:12 GMT

Count({$<SLA_Score={'>0<1'}>} distinct [INC Number])

Re: Greater Than and Less Than?

Anil_Babu_Samineni — Wed, 23 Aug 2017 04:11:55 GMT

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

Re: Greater Than and Less Than?

Wed, 23 Aug 2017 11:38:51 GMT

Thank You! That appears to be working! Not sure why i didnt think to put the conditions into the same set.