Skip to main content
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Expression to show monthly spend for the whole year

Hi...I need some guidance on how to create an expression to show the monthly spend for the 12 months.

Basically, I will have 12 columns showing the months.  Our financial year starts at April so month 1 will be April, month 2 will may May etc.

In each column I need to show the PTD-Actual spend for that month.

I'm not sure about the syntax I need for the expression.  sum(PTD-Actual)...................


Labels (1)
  • Other

1 Reply
Partner - Contributor II
Partner - Contributor II

Hi, can you share a sample of your data ?