Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
In QlikView I wrote the following expression to sum the quantity of all orders that are after a certain date:
sum ({$<DATE={">=29.Nov.2017"}>}QUANTITY)
now I try to change the certain date (29.Nov.2017) with an expression that will calculate a past date dynamicaly based on another number field in the table (COLUMN2).
date(today()- "COLUMN2",'DD.MMM.YYYY')
each expression is working independently but when I try to combine them like below it doesnt work:
sum ({$<DATE={">={"date(today()- "COLUMN2",'DD.MMM.YYYY')"}"}>}QUANTITY)
I am sure I don't write the combined expressions in the correct way but I don't know what I do wrong.
Thanks in advance to anybody that can point me in the right direction.
Hi Cornel,
Try to use the dollar-sign expansion for the nested expression in the Set analysis:
sum({$< DATE = {">=$(=date(today()-"COLUMN2",'DD.MMM.YYYY'))"} >} QUANTITY)
Hope this helps,
Radovan
Better to remove double quotes from field