Solved: How to hide Calculated dimension text on axis ?? - Qlik Community

nikhilgarg · ‎2014-09-30

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

Report Inappropriate Content · ‎2014-09-30

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

View solution in original post

PrashantSangle · ‎2014-09-30

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-09-30

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

sushil353 · ‎2014-09-30

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

nikhilgarg · ‎2014-09-30

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 ??

Report Inappropriate Content · ‎2014-09-30

use match function

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

if it doesn't work out try using wildmatch function

PrashantSangle · ‎2014-09-30

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

nikhilgarg · ‎2014-09-30

Hey it still does not work.

I have used Calculated dimension as :

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

And used match , wildmatch but no results...

Report Inappropriate Content · ‎2014-09-30

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

nikhilgarg · ‎2014-09-30

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