Skip to main content
Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for 
Search instead for 
Did you mean: 
imtiazgirach
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)...................

Thanks

Labels (1)
  • Other

1 Reply
here2h3lp
Partner - Contributor II
Partner - Contributor II

Hi, can you share a sample of your data ?