Using dimension value in expression

Tue, 13 May 2014 08:57:59 GMT

Hello!

I have dimension Month and "sales per month" expression. I also want two more expressions:

first - Sum of all previous sales prior to month start

second - Sum of all previous sales prior to month end

I think expressions should be like

Sum({<SalesDate={"<monthstart(Month)"}>} Sales)

Sum({<SalesDate={"<monthend(Month)"}>} Sales)

topic Using dimension value in expression in QlikView