topic Re: Accumulation values for the selection in the chart in QlikView

Accumulation values for the selection in the chart

Tue, 25 Jun 2013 05:51:41 GMT

Hi all,

I am showing one line chart with the fullaccumulation.By default it is showing all the data with the accumulated values and it is fine.

But if i made any selections in the chart,the accumulation is happening for those selected values only.Please help me to achieve this.

Ex: Sample Data

Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008

10 20 25 12 5

FullAccumulation:(By Default) ------>Fine

Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008

10 30 55 67 72

Selections(Feb-2008+Mar-2008+ Apr-2008) ---->Current Scenario

Feb-2008 Mar-2008 Apr-2008

20 45 57

But I need ----->Required Like this

Feb-2008 Mar-2008 Apr-2008

30 55 67

Please find the attachment for your referance.

Thanks in advance.

Regards

Kumar

Re: Accumulation values for the selection in the chart

Anonymous — Tue, 25 Jun 2013 06:52:02 GMT

Adding a '1' into the beginning of the set tells it to show all and ignore selections.

Find attached.

Jonathan

Re: Accumulation values for the selection in the chart

Tue, 25 Jun 2013 07:06:57 GMT

Hi Jonathan,

Thanks for your reply.

I want the values with accumulate for the selections

Please find the attachment and see the below chart

Regards

Kumar

Re: Accumulation values for the selection in the chart

Anonymous — Tue, 25 Jun 2013 07:51:11 GMT

Adding the test for >=$(vMinDate) into your set seems to work. See attached.

Jonathan

Re: Accumulation values for the selection in the chart

Tue, 25 Jun 2013 08:33:16 GMT

Hi Jonathan,

Sorry,This is not how i required.

If i made any range of seelctions in the chart the accumulation is happening from the selected selections only.(Not from the Jan-2008).

That is why the chart is not showing the default accumulated values how it shown for the full data for the filtered seelctions.

Please gothrough my first post.

Regards

Kumar

Re: Accumulation values for the selection in the chart

Anonymous — Tue, 25 Jun 2013 08:41:56 GMT

Maybe add a starting balance value, by setting up a variable that says something like:

=Sum({1<T_Date={"<$(vMinDate)"}>} Value)

Then add this in to the expression you use.

Jonathan

Re: Accumulation values for the selection in the chart

Anonymous — Tue, 25 Jun 2013 08:54:23 GMT

File attached.

Jonathan

Re: Accumulation values for the selection in the chart

Tue, 25 Jun 2013 09:25:26 GMT

Hi Jonathan,

The Startbal value is adding to the each and every value like this

Startbal + first value

Startbal*2+ second value

Startbal*3+ third value

etc

Hence the values are wrong.

Regards

Kumar

Re: Accumulation values for the selection in the chart

Anonymous — Tue, 25 Jun 2013 11:47:35 GMT

A test for if(RowNo()=1,....) might help.

Jonathan

Re: Accumulation values for the selection in the chart

Fri, 28 Jun 2013 02:45:59 GMT

Hi Jonathan,

Sorry for the late reply

This is also not giving the actual result.

Regards

Kumar