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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
ahmedwank
Contributor III
Contributor III

cumulative sum %

hello

i've tried  to calculate a cumulative sum in % but i didnt succeed,  that's a simple table as a graphic and i would like to cumulate the calculated column "count(commandes.code_article)" displayed in % 

if someone can help me please

thanks

1 Solution

Accepted Solutions
QFabian
MVP
MVP

Hi @ahmedwank , i just created a dummy table with this :

LOAD * INLINE [
F1, F2
6963, 3
6866, 2
6954, 7
];

Then i created a straight table with :

QFabian_0-1609369192131.png

 

First expression :

QFabian_1-1609369228964.png

Second expression :

QFabian_2-1609369257779.png

and the third :

QFabian_5-1609369734658.png

 

and looks like this :

QFabian_6-1609369782388.png

you can use it with your own data and see whats happens.

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

View solution in original post

2 Replies
QFabian
MVP
MVP

Hi @ahmedwank , i just created a dummy table with this :

LOAD * INLINE [
F1, F2
6963, 3
6866, 2
6954, 7
];

Then i created a straight table with :

QFabian_0-1609369192131.png

 

First expression :

QFabian_1-1609369228964.png

Second expression :

QFabian_2-1609369257779.png

and the third :

QFabian_5-1609369734658.png

 

and looks like this :

QFabian_6-1609369782388.png

you can use it with your own data and see whats happens.

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
ahmedwank
Contributor III
Contributor III
Author

Thanks, that's perfect !