How to hide Calculated dimension text on axis ??

[nikhilgarg]

Hey,

I have used a calculated dimension .

Dimensions are:   Maturity Month and Maturity Year. I have used like :  [Maturity Month]&'-'&[Maturity Year]. But the same is being shown as legend. I Only want to show value of [Maturity Month]&'-'&[Maturity Year] as dimension but [Maturity Month]&'-'&[Maturity Year] is also being shown as text. How to hide dis ??

And also i want Maturity Month  and Maturity Year to come in ascending order but they are coming in random order. How to sort it ??

Thanks

[#2]

it is working for me try the below application you need to write wildmatch function in the sort tab in that calculated dimension

p.s: never mark an answer as answered until you get the exact answer bcoz qv techies skip those questions that is answered so that you cant get the answer you are looking for

[nikhilgarg]

HEy,

I am using personal edition of qlikview so cannot open your qvw. Can you tell me the steps here ??

thanks

[nikhilgarg]

HEy,

I tried this . Logic is nice and good but the problem is Now it is coming in order ::

JAn2010 , Jan2012 , Feb 2010 , Feb 2014 , Mar2011, Mar 2013....

But i want in order like ::

JAn2010, Feb 2010, Mar2011,Jan2012 ,Mar 2013,Feb 2014......

What to do???

Thanks

[#5]

Go to sort tab in chart properties and by clicking the dimension right side check the expression and below that write the expression as

Wildmatch(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

write exactly what you have in your month field bcoz wildmatch function is a case sensitive function

[nikhilgarg]

HEy,

I tried this Now it is coming in order ::

JAn2010 , Jan2012 , Feb 2010 , Feb 2014 , Mar2011, Mar 2013....

But i want in order like ::

JAn2010, Feb 2010, Mar2011,Jan2012 ,Mar 2013,Feb 2014......

What to do???

Thanks

[#7 · Accepted solution]

then you want to represent both year and month in the expression like

wildmatch(month&'-'&year,'jan-2010','feb-2010','mar-2010',..........,'sep-2014','oct-2014')

[PrashantSangle]

Hi,

then instead of using calculated dimension.

combine the field in script.

then convert it in date format

use that field in your chart.

try this in script

Date(Date#([Maturity Month]&'-'&[Maturity Year],'MMMYYYY'),'MMMYYYY') as NewMonthYear

Use this field in your script

And sort it.

Regards