topic Re: How to insert IF statement in a set analysis? in QlikView

How to insert IF statement in a set analysis?

Wed, 21 Jan 2015 09:38:04 GMT

I want to create a set analysis that would select a subset of values only if a particular condition is verified but, it seems not possible to insert an if into { }.

Re: How to insert IF statement in a set analysis?

Gysbert_Wassenaar — Wed, 21 Jan 2015 09:45:20 GMT

Can you explain what you're actually trying to do? Preferable with an example with source data and the result data you expect.

Re: How to insert IF statement in a set analysis?

Anonymous — Wed, 21 Jan 2015 09:45:59 GMT

This might be of help:

http://community.qlik.com/message/208688

Re: How to insert IF statement in a set analysis?

vikasmahajan — Wed, 21 Jan 2015 09:51:26 GMT

SUM(AGGR(if(((max({$<[Expiration Date]-={'01/01/1753'}>}[Expiration Date]) - vDateForAgeing >=1

and max({$<[Expiration Date]-={'01/01/1753'}>}[Expiration Date]) - vDateForAgeing <= 30) ),SUM(Inv_Val)),Location_Code, Item_Code))/100000

This way you can use if in set analysis

HTH

Vikas

Re: How to insert IF statement in a set analysis?

Wed, 21 Jan 2015 10:02:34 GMT

We wont to have somenthing like this:

Date is our date dd.mm.yyyy

Day is our day column

Jobs is what we wont nullcount

we wont write something like this:

=NULLCOUNT ({<Date = { <= '(if ( Date ='Monday' ,date(Date - 3), if( Day='Sunday', date(date-2), date(Date-1))))'}>} Jobs)

I want specify that if statement is correct because we tested it.

Re: How to insert IF statement in a set analysis?

Gysbert_Wassenaar — Wed, 21 Jan 2015 10:07:07 GMT

A set analysis expression calculates a set at the chart level, not at row level. That's why you cannot use a set analysis expression. You need to use an if statement.

Re: How to insert IF statement in a set analysis?

krishna20 — Wed, 21 Jan 2015 10:07:53 GMT

Hi,

If you wanna check the condition between two fields the following one will works.

=((if((CLM_STATUS <>'C' or (CLM_STATUS='C' ),

(sum({<CE_EST_TYPE={"=CE_EST_TYPE=1"},CE_DT={"=CE_DT<=Today()"},

CLM_SOURCE_FM={"=CLM_SOURCE_FM=CE_SOURCE_FM"},

CLM_COMP_CODE={"=len(trim(CLM_COMP_CODE))>0"}>}CE_AMT_LC_1)

Regards

Krishna

Re: How to insert IF statement in a set analysis?

Wed, 21 Jan 2015 10:24:22 GMT

how would you write this?

we try also with only if statement but it doesn't work too.

=if(Date<=(if ( Day='Monday' ,date(Date - 3),

if(Day='Sunday', date(Date-2), date(Date-1)))),NullCount(Jobs))

Re: How to insert IF statement in a set analysis?

krishna20 — Wed, 21 Jan 2015 10:46:37 GMT

Hi ,

can you please post actual fields you have.I'm not getting to which date field you are comparing with.

Regards

Krishna