topic Show data on axe in QlikView

Show data on axe

Anonymous — Thu, 26 Jan 2012 15:53:30 GMT

Hi,

I have a stacked chart with values inside segments. I'd like to show sample size (total) on axe (or other place). Could you suggest anything?

Please find attched file.

Thanks,

Re: Show data on axe

Thu, 26 Jan 2012 16:17:12 GMT

You could add text in chart.

And then select the graph and press ctr and shift, so you can move the elements in the graph.

See the attached file.

Re: Show data on axe

Anonymous — Thu, 26 Jan 2012 16:41:29 GMT

Thanks for your help,

It's a very good idea!!!

Maybe somebody else suggest something.

Re: Show data on axe

Anonymous — Thu, 26 Jan 2012 16:52:13 GMT

What do I do, when columns 2, 3 or 4?

Re: Show data on axe

matt_crowther — Thu, 26 Jan 2012 17:07:54 GMT

This was trickier than it should have been.

Attached is a solution that should work across all columns and regardless of what Dimension values are selected.

Note the addition of a new v_Dim variable and the new Expression set to 'Text on Axis' and not 'Bar'.

Hope it solves it,

Matt - Visual Analytics Ltd

New Qlikview Design Blog: http://QVDesign.wordpress.com

Re: Show data on axe

Anonymous — Thu, 26 Jan 2012 19:42:51 GMT

Hi Matthew,

It works, but not when you need to select the last month.

Please find my attached file. Maybe I did something wrong.

Thanks,

Re: Show data on axe

Anonymous — Thu, 26 Jan 2012 19:52:50 GMT

I use this for % in expression

Count({$<Year={'$(=MonthName(max(Year)))'}>}Dimension)/

Count({$<Year={'$(=MonthName(max(Year)))'}>}TOTAL <Year>Dimension)

Thanks,

Re: Show data on axe

Anonymous — Mon, 30 Jan 2012 21:00:16 GMT

Any thought?

Re: Show data on axe

Anonymous — Thu, 09 Feb 2012 20:03:05 GMT

any ideas?

Show data on axe

Thu, 17 May 2012 10:00:55 GMT

Hmmm, I've tested the solution from Matthew but it doesn't work if the dataset isn't complete for each year. For instance, if you create Dec 2012 and only record C and D in the inline load, you won't see the sample size text on axis as shown here:

It seems like a good start, though.

Sample size below bars is very, very common in market research decks. Surely someone out there has thought of a way to do this?

Show data on axe

Anonymous — Thu, 17 May 2012 14:25:55 GMT

try this.

Create a new variable

vNew=MinString(Variable)

In chart use an expression

IF(Variable=vNew, Count(TOTAL <Your Time Variable> Variable),'')

Re: Show data on axe

Fri, 18 May 2012 02:14:17 GMT

My dataset is different from yours (no time data) but the situation is similar.

Your solution is essentially the same as Matthew's solution offered above, right?

My variable is v_brand. It's calculated as:

v_brand=minstring(Brand)

I have an expression in my bar chart:

if (Brand = v_brand,count(distinct total<[POS]>ResponseID,'')

I'm still finding that if the brands included in each bar are different (i.e, some bars don't have all of the brands represented), the text on axis does not correctly display the count (it shows blank).

Furthermore, the dimension names at the bottom are completely displaced by the blank spaces in the Else statement...

Re: Show data on axe

Anonymous — Fri, 18 May 2012 13:36:23 GMT

maybe something is wrong. I used this expression for most my charts. I didn't find better solution than this.

Re: Show data on axe

Mon, 21 May 2012 09:06:43 GMT

I think whether the expression works or not depends on your data. If you have "complete" data (i.e, if you have one value for every dimension in each set of data), then I think it works fine. If some are missing, though (for example, you have no data for one item for a particular month), it seems like issues arise.