topic How to hide Calculated dimension text on axis ?? in QlikView

How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 05:40:22 GMT

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

Re: How to hide Calculated dimension text on axis ??

PrashantSangle — Tue, 30 Sep 2014 05:45:18 GMT

Hi,

In dimension tab->select dimension->below that->Label->Write Name as you required.

If you want calculated LAbel then write with

='text'& - &'text'

Regards

Re: How to hide Calculated dimension text on axis ??

Tue, 30 Sep 2014 05:47:23 GMT

In the chart properties window you will have a label in the dimension tab by using that you can change the label of the calculated dimension. If that is what you want

and coming to sorting you can find sort option in the sort tab in the chart properties so you can make use of your own

Re: How to hide Calculated dimension text on axis ??

sushil353 — Tue, 30 Sep 2014 05:48:13 GMT

Hi,

Have you tried to write the same thing in label box under dimension tab ?

for sorting please post sample data.. you need to write expression in sort tab..

HTH

Sushil

Re: How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 05:54:48 GMT

HEy,

I have tried that but no result.

I want to sort x axis Value (Calculated dimension) according to Year and month Like jan-2010 , Feb 2011 , MAr 2012.

Please tell how to do this ??

Re: How to hide Calculated dimension text on axis ??

Tue, 30 Sep 2014 05:59:44 GMT

use match function

match( 'Jan','Feb','Mar'..............)

if it doesn't work out try using wildmatch function

Re: How to hide Calculated dimension text on axis ??

PrashantSangle — Tue, 30 Sep 2014 06:01:36 GMT

Hi,

Try to sort like this,

Select Dimension

Perform 2 sort on it.

Sort tab->

1: select Expression->Wildmatch([Maturity Month],'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

2:Numeric Value->Ascending.

Regards

Re: How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 06:03:28 GMT

Hey it still does not work.

I have used Calculated dimension as :

[Maturity Month]&'-'&[Maturity Year]

And used match , wildmatch but no results...

Re: How to hide Calculated dimension text on axis ??

Tue, 30 Sep 2014 06:10:07 GMT

What is the data that you have respective to [Maturity Month]&'-'&[Maturity Year] this dimension

Re: How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 06:12:33 GMT

Maturity Month: Jan-Dec and MAturity Year: 2010-2016 for insurance purpose.

Re: Re: How to hide Calculated dimension text on axis ??

Tue, 30 Sep 2014 06:26:45 GMT

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

Re: How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 06:34:51 GMT

HEy,

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

thanks

Re: How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 06:36:46 GMT

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

Re: How to hide Calculated dimension text on axis ??

Tue, 30 Sep 2014 06:40:42 GMT

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

Re: How to hide Calculated dimension text on axis ??

nikhilgarg — Tue, 30 Sep 2014 06:52:50 GMT

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

Re: How to hide Calculated dimension text on axis ??

Tue, 30 Sep 2014 06:58:15 GMT

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')

Re: How to hide Calculated dimension text on axis ??

PrashantSangle — Tue, 30 Sep 2014 07:04:45 GMT

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