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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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