Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have multiple qlikview files where I'm not able to see any data (graph/ table data) after manual/scheduled reload until i select a date in the date box. Below is the logic i used in the qlikview files,
Kindly help me in fixing this issue. I want to get the graph/table data after reload without selecting any date.
variables defined in edit script :
LET varMinStart=Date ( Today()-10 ,'DD-MM-YYYY' ) ;
LET varMaxStart=Date ( Today(),'DD-MM-YYYY' ) ;
From Date Box Logic:
Input style: calender
variable: varMinStart
min Value Logic: =Floor(Date(Today()-10,'DD-MM-YYYY'))
max value logic: =varMaxStart
To Date Box:
Input style: calender
variable: varMaxStart
min Value Logic: =varMinStart
max value logic: =Floor( Date( Today(), 'DD-MM-YYYY' ) )
Thanks in Advance...
Hi @abhilash92
You use a date format in script and a numeric format in the calendar object
Use this in your script
LET varMinStart=NUM(Date ( Today()-10 ,'DD-MM-YYYY') ) ;
LET varMaxStart=NUM(Date ( Today(),'DD-MM-YYYY' ) );