Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Act sooner with Multivariate Time Series in Qlik Predict™: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show data on axe

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,

13 Replies
Anonymous
Not applicable
Author

try this.

Create a new variable

vNew=MinString(Variable)

In chart use an expression

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

Not applicable
Author

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...

Anonymous
Not applicable
Author

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

Not applicable
Author

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.