Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner
Partner

barchart percentage of total

Hi all,

I have a barchart with a dimension "Hour" and an expression "count({ $ < RecordTRX_D = {1}  >}distinct(Key_TRXD))"

Now they would like to see the percentage to the toal of all the hours.

How can I do this in my barchart?

I found something like  count(Value1)/ count(total <Hour> Value1)

But how can I use it with set analysis and the distinct?

The total of all the hours is 618.

For the first value it should be (2/618)*100= 0.32%

Regards,

Kris

Total.JPG

1 Solution

Accepted Solutions
sunny_talwar

This

Count({$< RecordTRX_D = {1}>}distinct(Key_TRXD)) /Count({$<RecordTRX_D = {1}>}distinct TOTAL (Key_TRXD))

Or just select relative on the expression tab

View solution in original post

2 Replies
sunny_talwar

This

Count({$< RecordTRX_D = {1}>}distinct(Key_TRXD)) /Count({$<RecordTRX_D = {1}>}distinct TOTAL (Key_TRXD))

Or just select relative on the expression tab

kris_vliegen
Partner
Partner
Author

Thanks Sunny,

sometimes it can be this easy...