topic Re: Show Total next to a bar in barchart in App Development

Show Total next to a bar in barchart

Anonymous — Sat, 16 Nov 2024 09:35:10 GMT

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

Re: Show Total next to a bar in barchart

sunny_talwar — Tue, 27 Jun 2017 11:32:37 GMT

May be this

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

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

Re: Show Total next to a bar in barchart

Anonymous — Thu, 29 Jun 2017 15:16:45 GMT

Hi Sunny,

This worked, thank you for your help.

Re: Show Total next to a bar in barchart

sunny_talwar — Thu, 29 Jun 2017 15:17:48 GMT

Awesome

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny