topic Problem with writing an expression in QlikView

Problem with writing an expression

germanmarket — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Problem with writing an expression

RadovanOresky — Mon, 22 Jan 2018 21:29:50 GMT

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

Re: Problem with writing an expression

Anil_Babu_Samineni — Tue, 23 Jan 2018 00:05:49 GMT

Better to remove double quotes from field