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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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