Dates in expression search filter

Anonymous — Mon, 26 Dec 2016 19:04:29 GMT

Colleagues, hi!

I have one simple table with Date field and some Sales value.

Next my script load second table only with one field Date2. This tables are not connected with each other and my task to make pivot table, which must contain Date2 dimension and sum(Value) for such logic

Date2	Expr
01.11.2016	Sales for 01.11 from Date1
02.11.2016	Sales for 01.11-02.11 form Date1
03.11.2016	Sales for 01.11-03.11 form Date1
04.11.2016	…
05.11.2016	…

This calculation must be implement only by expr, not in load script.

Have anybody ideas how to make it?

Thanks.

Re: Dates in expression search filter

lironbaram — Mon, 26 Dec 2016 19:11:39 GMT

use this expression

sum(if(Date2>=Date,Sales))

attach is an example

topic Dates in expression search filter in QlikView

Dates in expression search filter

Re: Dates in expression search filter