topic Re: How to create dynamic Dimension Label in Charts? in QlikView

How to create dynamic Dimension Label in Charts?

Mon, 01 Jun 2015 13:54:44 GMT

Dear Colleagues,

I'm trying to create into a Bar Charts dynamic name creation in the Dimension field.

Basically, I want to keep the original value for the "Name 1" first position and them for the remaining this should be visible other names as A, B, C, D depending on number of dimensions.

Please see below in the picture below the desired results:

I appreciate any good idea on how to create this calculated dimension

Thanks! Leandro

Re: How to create dynamic Dimension Label in Charts?

morganaaron — Mon, 01 Jun 2015 14:29:08 GMT

When you say "depending on the number of dimensions" - what are ABCD representing?

Re: How to create dynamic Dimension Label in Charts?

Mon, 01 Jun 2015 14:30:47 GMT

Hi, this is dynamic. it can be many depending on selection.

I would say it is never more than 5

Re: How to create dynamic Dimension Label in Charts?

morganaaron — Mon, 01 Jun 2015 15:16:21 GMT

What I mean is, are these values of a dimension, or are these dimensions themselves? It might help if you give an example of a situation alluding to what sort of data you're talking about

Re: How to create dynamic Dimension Label in Charts?

Tue, 02 Jun 2015 07:29:10 GMT

Hi,

My database contains the Name 1, Name 2, Name 3 and I cannot simple define the Name 1 = A, Name 2 = B since position in the chart change and I want to keep a sequence A,B,C...

In my view this should be calculated dimension depending on the Position in the chart: i.e. if this is position is 1 = Name 1, if position is 2 = "A", if position is 3 = "B"... something like this.

Since the position of each "Name" is very dynamic, I believe I should have some calculated dimension.

Re: How to create dynamic Dimension Label in Charts?

ankitaag — Tue, 02 Jun 2015 08:56:42 GMT

Hi,

Can you please provide a small dataset of your application to have a clear understanding.

Thanks and Regards,

Ankita

Re: How to create dynamic Dimension Label in Charts?

morganaaron — Tue, 02 Jun 2015 08:57:54 GMT

There may be other ways around it, but one way would be:

> Create a calculated dimension that uses ValueList (for example: ValueList('Name 1', 'A', 'B')

> Create a conditional expression to return your dimension value based on your expression value, for example:

=If(ValueList('Name 1', 'A', 'B')='Name 1', Sum({<Year={"=Rank(Sum(Sales))=1"}>}Sales),
If(ValueList('Name 1', 'A', 'B')='A', Sum({<Year={"=Rank(Sum(Sales))=2"}>}Sales),
Sum({<Year={"=Rank(Sum(Sales))=3"}>}Sales)))

This is an example that instead of returning the year, would return the values 'Name 1', 'A' and 'B' in order of rank and attribute an individual years sales to each bar in size order. It's worth noting these wouldn't be 'clickable' though, as it's a ValueList and not the true values, so I'm not sure if that's exactly what you're after?

Re: How to create dynamic Dimension Label in Charts?

Tue, 02 Jun 2015 13:56:50 GMT

Hi, I have added the qlikview file in the first message

Re: How to create dynamic Dimension Label in Charts?

morganaaron — Tue, 02 Jun 2015 14:10:33 GMT

See attached for an example of what I said below.

Re: How to create dynamic Dimension Label in Charts?

Tue, 09 Aug 2016 11:59:23 GMT

Please try like the below expression

=If(Aggr(Rank(Sum(Sales)),Customer)<=10,'A','B')