variable in Qliksense

[khadar]

Hi Team,

I am stuck in a situation where I am getting trouble with my variable.

 I have create the variable like  let Vlast_modified_date = peek('Last_updated_date','0','Report_date_table') 

now I am using it in where to filter the data like this 

Sample11:

load * 

from ....  Sales.xslx where date > $(Vlast_modified_date) . this is not working 

can you please help me on this 

[hic]

Try using single quotes:

Load * From ....  Sales.xslx where date > '$(Vlast_modified_date)' ;

If your Last_updated_date is interpreted and correctly formatted, this should work.

[justISO]

Hi, try to check and be sure that both 'date' and 'Vlast_modified_date' are the same format. You can try to add date() function for this. Maybe this can help to align variable and dimension.