Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
BtBread
Creator
Creator

Additional values in the bar chart poosible

Hi.

I am new to QlikSense.

it ist possible to add additional values to the bars in the chart.
something like this is desired:

20190621_000933.jpg

In addition to the value, I have to specify the change in %. Is that even possible?
Are there any possibilities?

Thanks.

1 Solution

Accepted Solutions
OmarBenSalem

Suppose :

Your Dimension: Year

Your Measure:  sum(Sales)

 

2 options:

 

1) add it in the dimension :

change it from : Year

to : Year 

&' ('& num(
aggr(
(sum(Sales)-Above(sum(Sales)))/Above(sum(Sales))
,[Year ])
,'# ##0%')
&')'

 

Result:

Capture.PNG

 

2) Use a combo chart:

as dimension : 

Year

as measures : 

a) sum(Sales)

b) (sum(Sales)-above(sum(Sales)))/above(sum(Sales)) (second axis)

 

Result:

Capture.PNG

View solution in original post

2 Replies
OmarBenSalem

Suppose :

Your Dimension: Year

Your Measure:  sum(Sales)

 

2 options:

 

1) add it in the dimension :

change it from : Year

to : Year 

&' ('& num(
aggr(
(sum(Sales)-Above(sum(Sales)))/Above(sum(Sales))
,[Year ])
,'# ##0%')
&')'

 

Result:

Capture.PNG

 

2) Use a combo chart:

as dimension : 

Year

as measures : 

a) sum(Sales)

b) (sum(Sales)-above(sum(Sales)))/above(sum(Sales)) (second axis)

 

Result:

Capture.PNG

BtBread
Creator
Creator
Author

great suggestions.

Thanks a lot.