Dimension Label to 1 Character - Qlik Community

Report Inappropriate Content · ‎2016-05-13

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 · ‎2016-05-13

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

sunny_talwar · ‎2016-05-13

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

Report Inappropriate Content · ‎2016-05-15

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 · ‎2016-05-16

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