topic Re: variable in Qliksense in App Development

variable in Qliksense

khadar — Mon, 25 Apr 2022 11:49:50 GMT

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

Re: variable in Qliksense

hic — Mon, 25 Apr 2022 12:16:03 GMT

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.

Re: variable in Qliksense

justISO — Mon, 25 Apr 2022 12:19:53 GMT

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.