Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum till period.

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?

11 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Can you post a sample file?

anbu1984
Master III
Master III

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

Not applicable
Author

@Jonathan Penuliar and @anbu cheliyan;

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

Not applicable
Author

1period.png     2period0.png

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?

jpenuliar
Partner - Specialist III
Partner - Specialist III

In set analysis you can do something similar to below:

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

jpenuliar
Partner - Specialist III
Partner - Specialist III

replace Date_In with Period.

vStartDate will be Period 1

vEndDate will be your selected Period

jpenuliar
Partner - Specialist III
Partner - Specialist III

or do something like

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

Not applicable
Author

It do not work.

PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂