topic Dimension Label to 1 Character in QlikView

Dimension Label to 1 Character

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a chart with 2 Dimensions:

Week - 1, 2, 3, 4, 5, 6, 7.....51, 52

Month - JAN, FEB, MAR, APR, MAY ....NOV, DEC

The change of Dimensions in the chart happens from a variable.

If varDimension = 1, Chart Shows by Month Dimension

If varDimension = 0, Chart Shows by Week Dimension

Question -

How to limit the Month Dimension to Show Labels (single character) like "J" for JAN, "F" for FEB, "M" for MAR .. "J" for JUN, "J" for JUL and so on ?

** Note that you can't use the single character labels as dimension because the data for JAN,JUN, JUL will get clubbed under "J"

trdandamudi — Fri, 13 May 2016 13:41:42 GMT

See if Dual() function will resolve this....

sunny_talwar — Fri, 13 May 2016 13:44:05 GMT

I agree, you need to use Dual function. What is the dimension that you are using right now?

Sun, 15 May 2016 23:05:44 GMT

As I said, the dimension changes based on the variable.

Also the Month Dimension is a table which has columns Month and MonthNumber.. For Example:

Apr 1,

May 2 and so on...

I still don't understand how dual function can resolve this.

sunny_talwar — Mon, 16 May 2016 10:21:28 GMT

May be if you can provide us a sample we might be able to help you better.