Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
gaddeonline
New Contributor III

How to show '50+' on the continuous dimension axis in a bar chart?

Hi Experts,

I have a bar chart with a continuous dimension axis. Please refer the attachment for your convenience.

The no of episodes shown at days 50 are not only the value at 50. it is also the sum of all the episodes beyond the 50(includes 50).

So I want to show '50+' instead of 50 on x-axis. I am having difficulties in using dimension limits as this graph have continuous axis.

All I want in the graph is, instead of '50' in the x-axis(Days), I want to display '50+'.

Can any one help with this?

Thanks and Regards

Mahesh Gadde

Tags (2)
2 Replies
MVP & Luminary
MVP & Luminary

Re: How to show '50+' on the continuous dimension axis in a bar chart?

You can't. '50+' is a text value, not a number. So it can't be part of a continuous axis. What you can do is add a text in chart object with the text '+' and position that object next to the 50 label of the x-axis.


talk is cheap, supply exceeds demand
galax_allu
Valued Contributor

Re: How to show '50+' on the continuous dimension axis in a bar chart?

Hi

Try this in expresso..

if(Days>=50,(aggr(sum(Sales),Days)),0)