Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I am new to QlikSense.
it ist possible to add additional values to the bars in the chart.
something like this is desired:
In addition to the value, I have to specify the change in %. Is that even possible?
Are there any possibilities?
Thanks.
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:
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:
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:
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:
great suggestions.
Thanks a lot.