Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
DanieleCancellieri
Contributor
Contributor

Store

Hi, i have to do a store with  some days given by an Excel file. How do I have to have a variable equal to a day?                       I think so:   

load*inline [
month, day
sep, 24/09/2021
oct, 25/10/2021];

Let vtoday = date(today(), 'DD.MM.YYYY');
let vmonth=month(today());

if $(vtoday)= '24/09/2021' then

store [table] into 'lib://....._$(vmonth).csv' (txt,delimiter is ';');

                                                                                                                                                 

1 Solution

Accepted Solutions
rubenmarin

Hi, you can thy with:

IF Exists('Day','$(vtoday)') THEN
  //STORE
ENDIF

Make vtoday variable with the same as the expected date, wich it seems to be:

Let vtoday = date(today(), 'DD/MM/YYYY');

Also it will be better to change 'Day' field name to another one less common and more meaningful like DayToLoadExcel

View solution in original post

3 Replies
rubenmarin

Hi, you can thy with:

IF Exists('Day','$(vtoday)') THEN
  //STORE
ENDIF

Make vtoday variable with the same as the expected date, wich it seems to be:

Let vtoday = date(today(), 'DD/MM/YYYY');

Also it will be better to change 'Day' field name to another one less common and more meaningful like DayToLoadExcel

PrashantSangle

Can you explain your requirement with sample data.? We will get more clarity on it.

 

Great dreamer's dreams never fulfilled, they are always transcended.
DanieleCancellieri
Contributor
Contributor
Author

Thanks!