topic Re: IF() to Set Analysis? in QlikView

IF() to Set Analysis?

Sahal — Tue, 23 Feb 2016 12:22:58 GMT

Hi,

I would like to know how to turn an if statement to a fully set analysis?.

=IF([Employment Category] = 'TEST', 
  SUM({$<[WorkedFlag] = {1} >} Time) - SUM({$<[AdditionalFlag] = {1} >} Time),
  SUM({$<[WorkedFlag] = {1} >} Time))

Thank you.

Re: IF() to Set Analysis?

Anonymous — Tue, 23 Feb 2016 18:01:22 GMT

Hi,

I guess the result will be two expressions, once you have two conditionals

SUM({$<[WorkedFlag] = {1},[Employment Category] = {'TEST'} >} Time) - SUM({$<[AdditionalFlag] = {1},[Employment Category] = {'TEST'} >} Time),
SUM({$<[WorkedFlag] = {1}, [Employment Category] -= {'TEST'} >} Time))

Best Regards,

Re: IF() to Set Analysis?

HirisH_V7 — Tue, 23 Feb 2016 18:09:17 GMT

Hi,

If should be there , if you want a conditional value, or you want to split the condition into two expressions means you can go with mauri suggestion.

What's Your desired output!!

-Hirish

Re: IF() to Set Analysis?

Sahal — Tue, 23 Feb 2016 18:56:55 GMT

I would like as my question was to replace my if statement (if possible) to only include an set analysis insted.

I do NOT want do make 2 expressions.

My desired output would be if i choose a user that have Employment Category "test" but only choose the user and not the column and the value "test" then the workflag - additional time will be shown.

however if i choose a user that do not have "test" then the calculation would be only workflag time.

Re: IF() to Set Analysis?

Sahal — Tue, 23 Feb 2016 19:00:05 GMT

Can it be as simple as getselectedvalue(employment category) = 'TEST' or something to try to find if there is a value in the field that has "test" and the have the 2 set analysis like i have it?

Re: IF() to Set Analysis?

Tue, 23 Feb 2016 21:37:54 GMT

How's about this...

SUM({$<[WorkedFlag] = {1} >} Time) -

SUM({$<[AdditionalFlag] = {1}, [Employment Category] = {"Test"} >} Time)

That second sum should only pick up where AdditionalFlag = 1 and Category = Test

Re: IF() to Set Analysis?

jagan — Wed, 24 Feb 2016 03:32:35 GMT

Hi,

Try this

SUM({$<[WorkedFlag] = {1} >} Time) - SUM({$<[AdditionalFlag] = {1}, [Employment Category]*={'TEST'} >} Time)

Regards,

Jagan.