Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

variable in within a variable help

Hi, i need some help putting a variable into an expression.

In my script i create the following variable..

SET vCurrentYearFiscalStartDate =DATE(FirstDayCurrentFiscalYear);

then also in the script i am using this expression..

LET vItemCount_Listings =

'COUNT({$<
[it_target_type]={"Listings"},
[ld_Dist]={"4"},
[ld_Outlet_Check_Date]={">=01/07/2012 00:00:00"}>}
[ld_Item_Description])';

The above is hard coded with a date (01/07/2012 00:00:00), i want to replace this date with the variable created before it but i cant seem to get it working.

Can anyone help please?

0 Replies