How to store Qvd on If condition

[Smeenakshi23]

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.

[shraddha_g]

can you share your script?

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

[Anil_Babu_Samineni]

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

[Smeenakshi23]

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

[madhumitha]

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!

[shraddha_g · Accepted solution]

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

[Smeenakshi23]

Thanks a lot 🙂

[Smeenakshi23]

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