QlikView App Dev

[venkanna_info]

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.

[passionate]

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]

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,