Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

How to show a column for Actual Totals and Budget totals

Hi Team,

 

I want to show the below output in pivot:-

Object ID| Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec|Jan|Feb|Mar|Actuals(Total-Sum of all months)

PR00001| 10|20|30|40|50|60|70|80|90|100|110|200|860

Similarly i want to show for budget.

 

Please find attached the screenshot of the output for the same:-

Can anyone please help ?

 

Thanks

 

1 Reply
jochem_zw
Partner
Partner

just use the month as a dimension, and set show totals to 'ON'

For sorting the calendar, think you have to use a fiscal calendar, see here:

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...