variable in within a variable help

hopkinsc — Tue, 09 Oct 2012 14:27:34 GMT

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?

topic variable in within a variable help in QlikView

variable in within a variable help