Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative Sum - Dimension Problem

Hi, friends from QlikView community. I'm a newbie here, but I trained day or two with cumulative sums.

I have a dataset with 6 dimensions:

- Year (Rok): 2014, 2013,02012 ...

- Month (Obdobie): 1.12.2014, 1.11.2014, 1.10.2014 ....

- Series (Seria): Plan / Reality (Uctovnictvo)

- Code (Kód): AZZZ, B07VRA, D01TSC ... - types of incomes and costs

- Phase (Faza): B01REAL, B02MIMOREAL .. - codes of Phases, in which incomes/ costs occur

- Amount (Ciastka) in EUR

I designed a dashboard (sheet) with a cumulative chart of a calculated expression (D01TSC-AZZZ)/AZZZ.

Expression is here:

((Rangesum(Above(total Sum({$<[Kód]={D01TSČ}>}Čiastka),0,RowNo(total))))

+(Rangesum(Above(total Sum({$<[Kód]={AZZZ}>}Čiastka),0,RowNo(total)))))/

(-1*(Rangesum(Above(total Sum({$<[Kód]={AZZZ}>}Čiastka),0,RowNo(total)))))

Everything works fine (I'm very proud of me :-)), but only when I select only one of the crucial dimension Series.

If I select both (Plan AND Reality), data are not identic with previous situation.

Situation Nr.1: Series = Plan, Cumulative result for Dec 2013 = 18,00% - OK

Snap_2014.07.08 11.03.12_001.jpg

Situation Nr.2: Series = Uctovnictvo, Cumulative result for Dec 2013 = 47,28% - OK

Snap_2014.07.08 11.04.01_002.jpg

Situation Nr.3: Series = Plan AND Uctovnictvo, Cumulative results for Dec 2013 differ from above

Snap_2014.07.08 11.04.26_003.jpg

The problem causes something wrong in manipulating dimensions in the expression, but I can't find it out 😞

Can U help me, pls. ?

Thanks in advance.

Duski

0 Replies