If statement help to avoid Concatenate

amit_saini — Wed, 30 May 2018 13:46:29 GMT

Hi Folks,

Below is my scenario:

I'm calling 'ABC' table again and again as Concatenate based on bold mark condition's (Date.tmp2) < 6 or Date.tmp2) < 5.

ABC:

LOAD

hour(Date.tmp2) as Time.tmp,

IF(hour(Date.tmp2) < 6, Date.tmp2-1,Date.tmp2) as Date.tmp

;

LOAD

num(Date) as Date.tmp2,

timestamp(Date) as Date_Org,

Facility_Id,

----

-----

FROM

[$(vDataPath)ABC.qvd]

(qvd)

Where Match(Facility_Id,'KOF','KISA','KSI','KBL','KKS','KUL','KBO','KCQ','KTX','KMX','KDT','KUS');

Concatenate

LOAD

hour(Date.tmp2) as Time.tmp,

IF(hour(Date.tmp2) < 5, Date.tmp2-1,Date.tmp2) as Date.tmp

;

LOAD

num(Date) as Date.tmp2,

timestamp(Date) as Date_Org,

Facility_Id,

----

-----

FROM

[$(vDataPath)ABC.qvd]

(qvd)

Where Match(Facility_Id,'KUK');

But I'm thinking of loading CAQ table only once by giving one if condition to avoid Concatenate , so I'm trying below , but looks like it's not working:

ABC:

LOAD

hour(Date.tmp2) as Time.tmp,

if(match(Facility_Id,'KOF','KISA','KSI','KBL','KKS','KUL','KBO','KCQ','KTX','KMX','KDT','KUS'),IF(hour(Date.tmp2) < 6, Date.tmp2-1, if(match(Facility_Id,'KUK'),IF(hour(Date.tmp2) < 5, Date.tmp2-1,Date.tmp2) )))as Date.tmp

;

LOAD

num(Date) as Date.tmp2,

timestamp(Date) as Date_Org,

Facility_Id,

----

-----

FROM

[$(vDataPath)ABC.qvd]

(qvd);

Please suggest why???

or any other better solution for this situation ?

Regards,

Re: If statement help to avoid Concatenate

Gysbert_Wassenaar — Wed, 30 May 2018 14:34:21 GMT

Perhaps like this:

ABC:

LOAD

hour(Date.tmp2) as Time.tmp,

if(match(Facility_Id,'KOF','KISA','KSI','KBL','KKS','KUL','KBO','KCQ','KTX','KMX','KDT','KUS') AND hour(Date.tmp2) < 6, Date.tmp2-1, if(match(Facility_Id,'KUK') AND hour(Date.tmp2) < 5, Date.tmp2-1,Date.tmp2),Date.tmp2) as Date.tmp

;

LOAD

num(Date) as Date.tmp2,

timestamp(Date) as Date_Org,

Facility_Id,

----

-----

FROM

[$(vDataPath)ABC.qvd]

(qvd);

Re: If statement help to avoid Concatenate

amit_saini — Wed, 30 May 2018 15:28:35 GMT

Thank you!

Regards,

topic If statement help to avoid Concatenate in QlikView

If statement help to avoid Concatenate

Re: If statement help to avoid Concatenate

Re: If statement help to avoid Concatenate