Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
Partner

Hi, can you share a sample of your data ?