Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 

pivot table question

hi..... i have a pivot table with dimensions  Period, Actuality(AC,BU), and CompanyCode and expressions some of valuesX and sum of valuesY.


  1. 1. When select Year and Month, Pivot Table will display Actual (AC) and Budget (BU) values of the selected period and only Actual (AC) value of previous period corresponding to the selected Year and Month.
    For example,
    - When Year 2013 and Month 8 are selected, Pivot Table will display AC 201307, AC 201308, and BU 201308 of both expressions
    - When Year 2013 and Month 7 are selected, Pivot Table will display AC 201306, AC 201307, and BU 201307 of both expressions
    - so on and so forth.
1 Reply
MVP & Luminary
MVP & Luminary

Re: pivot table question