topic Re: Metric display based on month selection in QlikView

Metric display based on month selection

Wed, 23 Oct 2013 06:22:20 GMT

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.

Re: Metric display based on month selection

saumyashah90 — Wed, 23 Oct 2013 06:32:56 GMT

hey anushree try loading this and use it.

Re: Metric display based on month selection

sujeetsingh — Wed, 23 Oct 2013 06:38:23 GMT

See this

Re: Metric display based on month selection

Wed, 23 Oct 2013 06:40:46 GMT

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

Re: Re: Metric display based on month selection

Wed, 23 Oct 2013 06:52:07 GMT

Below is the Required format of chart display

Re: Metric display based on month selection

qlikpahadi07 — Wed, 23 Oct 2013 11:40:24 GMT

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

Re: Metric display based on month selection

saumyashah90 — Wed, 23 Oct 2013 11:51:27 GMT

Try this things