Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

birkirbjorns
New Contributor III

Show Total next to a bar in barchart

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

Barchart.PNG

3 Replies

Re: Show Total next to a bar in barchart

May be this

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

or

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

birkirbjorns
New Contributor III

Re: Show Total next to a bar in barchart

Hi Sunny,

This worked, thank you for your help.

Re: Show Total next to a bar in barchart

Awesome

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Community Browser