Qlik Community

App Development

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
birkirbjorns
Contributor III
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

Labels (1)
  • Chart

3 Replies
sunny_talwar

May be this

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

or

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

birkirbjorns
Contributor III
Contributor III
Author

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