topic Re: How to store Qvd on If condition in QlikView

How to store Qvd on If condition

Smeenakshi23 — Mon, 13 Nov 2017 04:25:18 GMT

Hello,

I am fetching some recipients from db and storing it as .csv file( To use in Nprinting). if today day is Monday only Monday data should get stored. Vice versa for all other days.

I have achieved the above scenario using where( sequence No =1) condition while fetching data from db and storing that as a Monday.csv, tuesday.csv.

I need to have only one qvd(instead of Monday.csv ,Tuesday etc) which replaces the data on day condition.

How to achieve this in Qlikview.

Re: How to store Qvd on If condition

shraddha_g — Mon, 13 Nov 2017 04:36:03 GMT

can you share your script?

You can Concatenate your new table with previous csv and then store new generated table in same csv

Re: How to store Qvd on If condition

Anil_Babu_Samineni — Mon, 13 Nov 2017 05:19:51 GMT

Have a look here using loop FOR EACH ... NEXT

Re: How to store Qvd on If condition

Smeenakshi23 — Mon, 13 Nov 2017 05:42:52 GMT

IF(DAY(TODAY()=1)) THEN

NoConcatenate

Monday:

LOAD *

FROM

(qvd)WHERE RPT_DAY= '1' ;

store Monday into C:\Qlikview\Data.csv(txt);

endif

IF(DAY(Today()=2)) THEN

NoConcatenate

Tuesday :

LOAD *

FROM

(qvd)WHERE RPT_DAY= '2';

store Tuesday into C:\Qlikview\data.csv(txt);

endif

IF(DAY(Today()=3)) THEN

NoConcatenate

Wednesday :

LOAD *

FROM

(qvd)WHERE RPT_DAY = '3';

store Wednesday into C:\Qlikview\data.csv(txt);

ENDIF

EXIT Script

I tired this, but it doesn't work

Re: How to store Qvd on If condition

madhumitha — Mon, 13 Nov 2017 05:52:26 GMT

Hi Soundarya,

This is exactly where you need to use Switch case statement.

please refer below qlikview help link

Switch..case..default..end switch ‒ Qlikview

Thanks!

Re: How to store Qvd on If condition

shraddha_g — Mon, 13 Nov 2017 06:26:43 GMT

Try:

IF(DAY(TODAY()=1)) THEN

Data:

LOAD *

FROM

(qvd)WHERE RPT_DAY= '1' ;

ENDIF

IF(DAY(Today()=2)) THEN

Data :

LOAD *

FROM

(qvd)WHERE RPT_DAY= '2';

ENDIF

IF(DAY(Today()=3)) THEN

Data:

LOAD *

FROM

(qvd)WHERE RPT_DAY = '3';

ENDIF

store Data into C:\Qlikview\data.csv(txt);

EXIT Script

Re: How to store Qvd on If condition

Smeenakshi23 — Mon, 13 Nov 2017 07:20:15 GMT

Thanks a lot 🙂

Re: How to store Qvd on If condition

Smeenakshi23 — Thu, 21 Dec 2017 06:49:17 GMT

hello Sharaddha,

I tried now and the above scenario is not working now. storing values for all the day(i.e) monday , tuesday and wednesday