Show Total next to a bar in barchart

[Anonymous]

Hi All,

I have a barchart and I would like to show on the barchart the total no. of sales ie. not broken down by hour. So the idea would be to give the user an sense of how the load is per hour compared to the total. So for example at 12 we have 3k sales and the total is 39k so it around 7,6 % of the total no of sales.

Count(distinct [TransactionNo])

Hopefully this makes sense. Any hints are appreciated and Ideas of presentation.

regards

Birkir

[sunny_talwar]

May be this

Count(DISTINCT [TransactionNo])/Count(TOTAL DISTINCT [TransactionNo])

or

Count(DISTINCT [TransactionNo])/Aggr(NODISTINCT Count(DISTINCT [TransactionNo]), Hour)

[Anonymous]

Hi Sunny,

This worked, thank you for your help.

[sunny_talwar]

Awesome

Please close the thread in that case by marking correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny