topic Re: Sum till period. in QlikView

Sum till period.

Wed, 29 Apr 2015 08:02:57 GMT

I have 13 periodes.

And I have also a table with many variables.

Now I want that when I select period 4, that there is a variable who have the sum of the omzet of periode 1, 2, 3 and 4.

Is that possible? And what is the formula?

Re: Sum till period.

jpenuliar — Wed, 29 Apr 2015 08:26:43 GMT

Can you post a sample file?

Re: Sum till period.

anbu1984 — Wed, 29 Apr 2015 08:36:42 GMT

Can you explain your requirement with sample data and post expected output

Re: Sum till period.

Wed, 06 May 2015 09:20:43 GMT

@Jonathan Penuliar and @anbu cheliyan;

I try to do that, but it is not easy.

Re: Sum till period.

Wed, 06 May 2015 09:38:17 GMT

1 2

1: The table. And in this one I want to fill in: total till this periode. But I don't know the formula.

2. All the periods. If I press on the 6 I see the datainformation of that period.

For example I have €100 demand in period 6. €50 in period 1,3 and 4, €60 in period 2, €110 in period 5. All in MAX Year = 2015.

I want that the formula if I press by period on 6. That the formula sums all the demands = €420

But what is the formula?

Re: Sum till period.

jpenuliar — Wed, 06 May 2015 10:32:58 GMT

In set analysis you can do something similar to below:

count({<Date_In = {'>=$(=date($(vStartDate)))<=$(=date($(vEndDate)))'}>}COUNTER)

Re: Sum till period.

jpenuliar — Wed, 06 May 2015 10:33:58 GMT

replace Date_In with Period.

vStartDate will be Period 1

vEndDate will be your selected Period

Re: Sum till period.

jpenuliar — Wed, 06 May 2015 10:36:58 GMT

or do something like

Sum({<Period = {'<= vPeriod'}>}Demands)

Re: Sum till period.

Mon, 08 Jun 2015 07:48:39 GMT

It do not work.

Re: Sum till period.

PrashantSangle — Mon, 08 Jun 2015 07:59:07 GMT

Hi,

what do you mean by do not work ???

It is not giving you data or giving you wrong sum.

Clearify your requirement.

Try

Sum({<Period={"<=$(=max(Period))"}}>}Demands)

regards

Re: Sum till period.

Mon, 08 Jun 2015 07:59:16 GMT

Can you help me?

Re: Sum till period.

jpenuliar — Mon, 08 Jun 2015 08:17:47 GMT

If not possible for you to send a sample file, I suggest you go through below:

QlikView How To (or Tips & Tricks) Application by Lee Matthews

http://community.qlik.com/docs/DOC-5486

you may be able to pick something from this great Tutorial.