topic Re: Displaying an expression as text on axis in QlikView

Displaying an expression as text on axis

bluecarbon — Fri, 05 Jan 2018 17:18:34 GMT

I have two dimensions, one Country and another a Date, And two expression one Units and other one as action. A country can take some action on a particular date and this field will have a value as 1 whenever an action is taken.

I want to display the 1 on x-axis whenever there is action taken on that particular date regardless of country. But the chart is displaying action for each country.

Is there any way to display only one value regardless of country count?

Thanks,

Rakul.

Re: Displaying an expression as text on axis

Anil_Babu_Samineni — Fri, 05 Jan 2018 17:48:21 GMT

Text on axis doesn't build for specific filter. Hence, It will apply for all dimension values which are respect or irrespective on field selector

Re: Displaying an expression as text on axis

bluecarbon — Fri, 05 Jan 2018 17:57:15 GMT

Thanks Anil,

Is there any way to aggregate the expression in text on axis? I want it to display only one 1 rather than many 1's for each dimensions.

Thanks,

Rakul.

Re: Displaying an expression as text on axis

Anil_Babu_Samineni — Sat, 06 Jan 2018 02:08:02 GMT

I didn't decipher as much. But, marcowedel‌ Have some insights?

Re: Displaying an expression as text on axis

MarcoWedel — Sat, 06 Jan 2018 21:52:21 GMT

Hi,

I guess you can't aggregate the text on axis values into one single text per month, but maybe you can replace your second (country) dimension with one expression per country each:

hope this helps

regards

Marco