topic Re: Show Text on Axis from Single Dimension in QlikView

Show Text on Axis from Single Dimension

Wed, 02 Dec 2015 19:13:34 GMT

Hello,

I have a chart with 2 dimensions and 2 expressions. The second expression is set to only show text on axis and I have an issue with it showing both values overlayed on each other. How do I get it to show the total count instead?

Thanks in advance!

-Jason

Re: Show Text on Axis from Single Dimension

sunny_talwar — Wed, 02 Dec 2015 19:15:04 GMT

Would you be able to share your sample?

Re: Show Text on Axis from Single Dimension

Wed, 02 Dec 2015 19:25:06 GMT

Hi Sunny,

Thanks for the quick response! Sample QVW attached.

-Jason

Re: Show Text on Axis from Single Dimension

sunny_talwar — Wed, 02 Dec 2015 19:27:40 GMT

This?

Count(TOTAL <Quarter> [Type])

Re: Show Text on Axis from Single Dimension

Wed, 02 Dec 2015 20:48:07 GMT

Hi Sunny,

That's very close. I forgot to mention that one of the dimensions is a group... how would I reference that instead of a field? I updated the sample with someone closer to what I have. I'm also using DISTINCT in the expression because I am actually using an ID field that contains duplicate ID values... will that cause issues with the expression?

Re: Show Text on Axis from Single Dimension

sunny_talwar — Wed, 02 Dec 2015 21:03:46 GMT

This?

Couple of changes made:

1) Script change:

LOAD *,

[Create Year] & '-' & [Create Quarter] as CreateYearQtr,

[Close Year] & '-' & [Close Quarter] as CloseYearQtr;

LOAD * INLINE [

Type, Value, Create Quarter, Create Year, Close Quarter, Close Year

A, 5, 1, 2016, 1, 2016

A, 5, 2, 2016, 2, 2016

B, 10, 2, 2016, 2, 2016

A, 5, 3, 2016, 2, 2016

B, 10, 3, 2016, 3, 2016

A, 6, 2, 2016, 2, 2016

B, 10, 3, 2016, 3, 2016

B, 1, 3, 2016, 3, 2016

];

2) New Expression:

If(Sum(Aggr(Count([Type]), $(=GetCurrentField([New Group])))) > 0,

Sum(Aggr(Count([Type]), $(=GetCurrentField([New Group])))), '')