Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using dimension value in expression

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)

0 Replies