topic Re: Display a value in a crosstable as a % value in QlikView

Display a value in a crosstable as a % value

datanibbler — Fri, 12 Apr 2013 10:32:15 GMT

Hi,

I have created a progress_tracker to visualize the status of the project. The absolute numbers are correct and the chart looks fine. Now I want to do the same, displaying % values - e.g. for one area (x-axis), there are four reports, two of them are done, so that should be 50%.

Can anybody lend me a hand here? For some reason, the relative values are garbage.

Thanks a lot!

Best regards,

DataNibbler

Re: Display a value in a crosstable as a % value

Gysbert_Wassenaar — Fri, 12 Apr 2013 13:41:36 GMT

You'll need to use the total keyword in your expression I think.

sum(Amount)/sum(total Amount) will calculate the % of the total over all dimensions of the chart.

If you need the percentage over a specific dimension(s) you'll need to include the dimension name(s) between < and > characters. For example sum(Amount)/sum(total <Product> Amount).

Re: Display a value in a crosstable as a % value

Wed, 24 Jul 2013 14:57:38 GMT

This is working and so simple..Thnx Gysbert