Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
venkanna_info
New 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
Highlighted
passionate
Valued Contributor

Re: Kindly help me on the below Query - Pivot Table

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))

Highlighted
venkanna_info
New Contributor

Re: Kindly help me on the below Query - Pivot Table

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,