topic Re: Inclding spaces also in set analysis in QlikView

Inclding spaces also in set analysis

Pulkit_Thukral — Wed, 10 Feb 2016 06:22:20 GMT

Issue is as followed:

i am writing a set analysis statement for counting tickets sla_value is not eual to detached ( SLA_Value-={'Detached'}).

But it is also excluding tickets where Sla_Value is blank(' '). I need those values to be included in the count and only the tickets with sla_value as Detached to be excluded.

Re: Inclding spaces also in set analysis

sunny_talwar — Wed, 10 Feb 2016 09:08:22 GMT

May be this:

{<SLA_Value -= {'Detached'}>+<SLA_Value = {"=Len(Trim(SLA_Value)) = 0"}>}

Re: Inclding spaces also in set analysis

avinashelite — Wed, 10 Feb 2016 10:37:58 GMT

one more approach would be is to add a flag for the null SLA_Value in the script and you could use the same in the set analysis

{<SLA_Value -= {'Detached'}>+<SLA_Value_Flag = {1}>}