How to add count to the x-axis label?

[#1]

Hi,

       I would like to add group counts to the x-axis label like the screenshot attached. I think dual function can be used in dimension definition, but just do not know how to implement it.

Thanks

Longmatch

[Gysbert_Wassenaar]

Something like this:

=dual( DimensionName & ' (' & aggr(count(MyField),DimensionName) & ')', DimensionName)

[#3]

I tried with your idea, but it does not work. Could you please check the sample in the attachment? Thanks

[#4]

It worked when it changed back to non-continuous axis. However, I do need this feature for continuous axis since the vertical line requires continuous axis. Can we still get it done? Thanks

[Gysbert_Wassenaar]

Not very prettily. You can add another expression for the count, make the line invisible and check the option Text on Axis. Looks something like this:

[#6]

Thanks. This solution is working and I will keep looking for other possibilities.

[#7]

Thanks for the great information!  I'm new to Qlikview (still learning).  I'm wondering how you were able to enter the word 'count' on the graph?  I have several graphs that I have counts on the x axis but have yet to figure out how to enter a label like you did?  Thanks!