Un-Group the Dimensions in Chart

[sureshbaabu]

Hello,

I have a requirement to represent a data by month using charts and I wanted to display the first character of the Month names as below

Qlikview groups the common fields together. So for Months,  All ‘J’,’A’ and ‘M’ are getting grouped

could you please assist me with the process to ungroup the dimension ?

Thanks

[Jason_Michaelides]

Try this as your dimension:

=Date(Month,'M')

This should only affect the formatting and not the underlying numerical value.

Hope this helps,

Jason

[sureshbaabu]

Hello Jason,

Thanks for your Response!!!

Could you pease explain in detail if you dont mind. I'm not getting it clearly.

For Eg:

My cloumn name is 'MONTH'

My data for column 'MONTH' is 'JAN,FEB, MAR,.....,DEC'

MY dimension is MONTH on the Chart.

Could you please help me with the Expression for the above example?

Thanks

[Jason_Michaelides]

Remove MONTH as the dimension.  Click the Add Calculated Dimension button and type:

=Date(MONTH,'M')

In the Label box on the dimension tab type 'Month'

See if that works,

Jason

[sureshbaabu]

Hello,

No, It does not work. It shows a null coulmn

Thanks

[Jason_Michaelides]

How did you get your MONTH field?  Is it text or a number (date) formatted as 'MMM' ?

If it is text then you will need to add this to the script:

LOAD

     Otherfields,

     Date(Date#(MONTH,'MMM'),'M')     AS     MONTH

FROM.....;

If you post your app I'll show you.

[sureshbaabu]

My data comes as a text. The above expression will give us only the numbers from 1 to 12 right?

LOAD

Month,
Date(Date#(Month,'MMM'),'M') AS MONTH_NEW,
Value
FROM
[test.xls]
(biff, embedded labels, table is

Sheet1$);

my dimension is 'MONTH_NEW' in the chart.

Thanks

[Jason_Michaelides · Accepted solution]

Yes - sorry.  Try:

Dual(Left(MONTH,1),Date#(MONTH,'MMM'))     AS     MONTH_NEW

The Date#() coverts the text into a date (numeric) field. Dual allows you to have similar looking values but with different underlying numeric values.

Now, in your chart if you use MONTH_NEW you should be good to go.

Jason

[sureshbaabu]

This is Awesome. It Worked.

Thank you taking your time in helping me.

I have learnt something new from new. Thanks a lot Jason

[Jason_Michaelides]

No worries.