Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Problem of sorting values in a pivot table (to get an accumulation of ratio)

Dear all,

I need your expertise to realize a cumulated/cumulative ratio in a Pivot Table.

Indeed you can see in my example that I meet some difficulties :

- the sorting (column Rank) doesn't work like I want. My values must be sorted by decreasing Turnover (even if I decide to collapse or expand all)

- since my column Rank is false, you can see my columns Ratio and Cumul Ratio (which accumulates the values of the column Ratio) are false too

Thanks in advance for your feedbacks,

Best regards,

Benjamin

4 Replies
Not applicable

Re: Problem of sorting values in a pivot table (to get an accumulation of ratio)

sort by Y-value descendingen

Not applicable

Re: Problem of sorting values in a pivot table (to get an accumulation of ratio)

Thanks for your answer.

But I had already tried this sorting and it doesn't work .

Indeed if I sort by Y-value descending the cumul ratio is false

Not applicable

Re: Problem of sorting values in a pivot table (to get an accumulation of ratio)

Any idea please?

skchen97
New Contributor

Re: Problem of sorting values in a pivot table (to get an accumulation of ratio)

Load the same set of data group by dimension columns with sum and sort by sum

Community Browser