topic Re: Dynamic label name in QlikView

Dynamic label name

priyarane — Mon, 07 Sep 2015 17:28:30 GMT

Hi Community,

I have a list box(Dim1),and one straight table dimension for straight table(X_Dim).

values:

Dim1

in straight table dimennsion(X_Dim) it should dim1 values it means that what I ever I select in Dim1 and then for X_Dim label should be same.

ex:

If I select X in Dim1 and label will be X for X_Dim(Straight table Dimension)

Re: Dynamic label name

sunny_talwar — Mon, 07 Sep 2015 17:35:30 GMT

Not entirely sure what you are trying to do. Can you share some numerical sample data with expected output?

Re: Dynamic label name

priyarane — Mon, 07 Sep 2015 17:42:31 GMT

Hi Sunny,

Label name should change what I ever I select in my list box.

Ex:

Dim1

And I have used one dimension: X_Dim in Chart for this name(Label) should change accordingly what ever I select in list box.

Re: Dynamic label name

sunny_talwar — Mon, 07 Sep 2015 17:45:03 GMT

What if you use GetFieldSelections(Dim1) in your label?

Re: Dynamic label name

malini_qlikview — Mon, 07 Sep 2015 17:47:41 GMT

Hi,

Do you mean that what selections are made on Dim1, should be displayed as the label for the dimension in the straight table?

If so, try using GetFieldSelections(Dim1) in the label

Re: Dynamic label name

priyarane — Mon, 07 Sep 2015 17:55:23 GMT

in this case other names also will come..

I need x,y values only,

Dim1:

Z is for another Dimension in Straight table...

If(Dim1='X', then Label name 'X',if(Dim1='Y', then Label name 'Y') like this I need label name but If(Dim1='Z', then Dimension in Straight table is different.

Re: Dynamic label name

priyarane — Mon, 07 Sep 2015 18:01:45 GMT

in this case other names also will come..

I need x,y values only,

Dim1:

Z is for another Dimension in Straight table...

If(Dim1='X', then Label name 'X',if(Dim1='Y', then Label name 'Y') like this I need label name but If(Dim1='Z', then Dimension in Straight table is different.

Re: Dynamic label name

sunny_talwar — Mon, 07 Sep 2015 18:04:42 GMT

Priya I am not very sure what you are trying to say. If Dim1 = 'Z' then what would be the label??

Re: Dynamic label name

ecolomer — Mon, 07 Sep 2015 18:16:30 GMT

See this example

Re: Dynamic label name

jonas_rezende — Mon, 07 Sep 2015 18:25:01 GMT

Hi.

The solution was not obtained in this post below!?

https://community.qlik.com/thread/179532

Re: Dynamic label name

priyarane — Mon, 07 Sep 2015 18:28:06 GMT

That is selection of Dimension not for Label name

Re: Dynamic label name

priyarane — Mon, 07 Sep 2015 18:33:09 GMT

Hi Enrique,

In your example treat like below

Dimension - Company and Id would be same so Enable condition I have changed like: max(Match(Dimension,'Company','Id'))

so Label should come like, If I select Company from Dimension then Label/name: Company, if I select ID from dimension then Label should be: ID

PFA for this code

Re: Dynamic label name

maxgro — Mon, 07 Sep 2015 18:51:08 GMT

=only({$ <Dim1*={x,y}>} Dim1)