Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkanna_info
Partner - Contributor
Partner - Contributor

Kindly help me on the below Query - Pivot Table

Application Development

From the given data source (fact.qvd), please create QV Application with List Boxes and Pivot Table which looks and behaves as per described below:

Application contains:

  1. 1. List Box of Year and Month
  2. 2. Pivot Table which contains and is arranged as above picture
    1. 2.1. Dimensions of Period, Actuality, and CompanyCode
    2. 2.2. Expressions of sum of ValueX and ValueY
  3. 3. 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

Any technique/option/setting which should be applied to make the application work properly, please do not hesitate to do so.

Kindly help me on the 3rd Scenario.

2 Replies
passionate
Specialist
Specialist

Hi,

You can try something like this in expression:

Pick(Match(Actuality,'AC','BU'),sum({<Month={">=$(=Max(Month)-1)"}>}ValueX),sum({<Month={">=$(=Max(Month))"}>}ValueX))

venkanna_info
Partner - Contributor
Partner - Contributor
Author

but that expression is showing sum of valuesX and sum of valuesY witch i can achieve by giving Sum(valueX) and Sum(valueY) in expression but i want to keep acctuality AC as previous selection for both valueX and ValueY, plz go through the question2 you will understand clearly,