Metric display based on month selection

[#1]

Hi,

I have a requirement wherein there aretwo metrics(Value and Value%).I would want to display Value metric for all the months whereas Value % metric by default must be displayed for current month-1(i.e.,oct-1=sep),and when the user selects a particular month ,Value% metric of the selected month must get displayed.I have attached a sample application.Please let me know how this could be acheived.

[saumyashah90]

hey anushree try loading this and use it.

[sujeetsingh]

See this

[#4]

Hi Saumya,

The above approach  does not seem to serve the purpose as you are suggesting to create a new field and apply the same on the chart when this is done value also will get displayed only for the previous month whereas i want the value metric of all the months to be displayed and value% of previous month to be displayed by default and on selection of a particular month the value% of the selected month must be displayed

[#5]

Below is the Required format of chart display

[qlikpahadi07]

HI Anushree Shetty,

As updated I understand you can't change the Script but yes in QlikView we have options:

I have attached a sample application using Set Analysis You can achieve it by some other approach.

You can variable for % as Max(Month -1) for a record I am using Max selected

[saumyashah90]

Try this things