Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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
Partner

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
Partner

In set analysis you can do something similar to below:

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

jpenuliar
Partner
Partner

replace Date_In with Period.

vStartDate will be Period 1

vEndDate will be your selected Period

jpenuliar
Partner
Partner

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.