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

Kindly help me on the below Query - Pivot Table

venkanna_info — Mon, 12 Jun 2017 13:49:36 GMT

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. List Box of Year and Month
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. 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.

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

passionate — Mon, 12 Jun 2017 15:37:08 GMT

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

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

venkanna_info — Mon, 12 Jun 2017 16:19:30 GMT

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,