Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
abhilash92
New Contributor

Qlikview: Graph/Table data in is not displaying after reload.

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...

 

1 Reply
p_verkooijen
Valued Contributor

Re: Qlikview: Graph/Table data in is not displaying after reload.

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' ) );