Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display sum as data point above grouped bar chart

Hi, how do I sum up the 'inv turnover' (see in attached sample data) for each month and display it as a data point above the grouped bar chart like below? Each bar represents each site(see in attached sample data). Thanks.

Untitled.png

21 Replies
Not applicable
Author

Currently I have this:

Untitled2.png

Now I just need the sum for each month to be a data point on top. Thanks

ThornOfCrowns
Specialist II
Specialist II

Change the Dimension to:

 

=date(MonthYear,'MMM-YY')

Not applicable
Author

Yes, I already did that in edit script and I am using this new variable.

tresesco
MVP
MVP

With my screen shots, make the following changes:

Dimension1: Site

Dimension2: Date(MonthYear,'MMM-YY')

Second expression: =sum(TOTAL <Site> [Store Value])

Not applicable
Author

Is the attached what you mean

Not applicable
Author

Hmm...now its grouped in site and monthyear:

Untitled3.png

I'm using 'inv turnover' by the way:)

Not applicable
Author

Hi, sorry I can't open the file. Thanks

Not applicable
Author

Let me try again

Not applicable
Author

Hi,

I think I have achieved it. Please check and if somewhere my understanding is wrong then let me know.

Thanks.

Not applicable
Author

Hi, so sorry I can only open files I created myself as I'm using Personal Edition. Do you mind sending me screen shots instead? Thanks so much.