Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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.

so

  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
Highlighted
MVP & Luminary
MVP & Luminary

Re: pivot table question