topic Re: cumulative sum % in QlikView

cumulative sum %

ahmedwank — Wed, 30 Dec 2020 22:33:14 GMT

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

Re: cumulative sum %

QFabian — Wed, 30 Dec 2020 23:10:00 GMT

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 :

First expression :

Second expression :

and the third :

and looks like this :

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

Re: cumulative sum %

ahmedwank — Thu, 31 Dec 2020 00:07:14 GMT

Thanks, that's perfect !