topic Convert if statement to set analysis in qlikview? in QlikView

Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

My if statement is as follows:

IF(ISNULL(A),'No Receive Date',IF(B<>'Accepted',IF(LEN(C)>0,IF( LEN([D)>0, IF(D>C,'Delayed','On Time'),IF(NOW()-C<0,'On Time','Delayed')),'No Due Date'),'No Action')) as DELAYED

I am looking out for other options instead of using IF statement .

Please suggest me.

Re: Convert if statement to set analysis in qlikview?

sunny_talwar — Wed, 16 Nov 2016 09:30:54 GMT

This seems to be used in script, right? You cannot use set analysis in script. Also, not sure what issues you are running into, but if you can point the issue into, may be we can suggest another way to help you out here

Re: Convert if statement to set analysis in qlikview?

sushil353 — Wed, 16 Nov 2016 09:31:51 GMT

Hi Gireesh,

as this is conditional statement so, using IF is fine .. also i think you are using this condition in script so what is the issue of using if condition ?

Re: Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 16 Nov 2016 09:36:38 GMT

Yes, I am using this at script level, I am calculating field DELAYED based on other fields.

Re: Convert if statement to set analysis in qlikview?

sunny_talwar — Wed, 16 Nov 2016 09:38:18 GMT

So set analysis is out of option here. Now why do you not want to use if? Are you getting any errors?

Re: Convert if statement to set analysis in qlikview?

Wed, 16 Nov 2016 09:49:49 GMT

You are going to derive something, it is not possible to derive values like if in SETANALYSIS.

Re: Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 16 Nov 2016 09:53:29 GMT

If condition working good.But data is more then 50 lakhs.So if we use if condition performance will kill.Thats why i am looking other way.

Re: Convert if statement to set analysis in qlikview?

sunny_talwar — Wed, 16 Nov 2016 09:55:15 GMT

Backend performance won't be heavily impacted using if statement, besides I don't even think you have another better way to do this.

Re: Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 16 Nov 2016 09:57:14 GMT

IF Condition kill the performance.So i am looking other way...

Re: Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 16 Nov 2016 10:00:34 GMT

Hear if condition checking each and every row.so loading data taking so much of time.

Re: Convert if statement to set analysis in qlikview?

sushil353 — Wed, 16 Nov 2016 10:02:14 GMT

Why don't you try to put the condition at SQL level

Re: Convert if statement to set analysis in qlikview?

sushil353 — Wed, 16 Nov 2016 10:02:42 GMT

There you would have more tuning options.

Re: Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 16 Nov 2016 10:13:21 GMT

I am getting data from share point not database.

Re: Convert if statement to set analysis in qlikview?

gireesh1216 — Wed, 16 Nov 2016 10:23:40 GMT

Thank you all