Show Label instead of Formula on the Header

[rammuthiah]

When select a particular or whole thing, In header, formula is displaying that are given in Edit Expression. Can we show the label instead of Field?

[pooja_sn]

Assign a label to your expression.

[vishsaggi]

Hello Ram,

What sheet object/chart are you using in this ? However, just wanted to know is this in Qlikview or Qliksense?

In Qlikview if you using Pivot Table or Straight Table You have a label Option in Dimensions Tab if calculated dimensions were used and in Expression Tab you can give a label.

If this is in Qliksense, please repost this query in Qliksense for faster response.

Thanks,
V.

[phaneendra_kunc]

Do you have a calculated dimension? try moving that over to script instead of doing on grid in UI.

[rammuthiah]

Thanks Vishsaggi, This occurs in Qlik Sense. And don't know how to repost in Qlik Sense forum. Qlik view and Qlik sense are same community it seems.

[Anonymous]

Hi Ram,

There are separate spaces for QlikView and Qlik Sense. I have moved this thread to the Qlik Sense space.

Best regards,

Qlik Community Team

[rammuthiah]

Thanks Phaneendra, I need the calculated dimension for this table alone. So I don't need to do this in script

[phaneendra_kunc]

There is no solution for this in current release of Sense as far as i know.

If you have a calculated dimension and when you select any value from it, then in current selections box, you will see the IF statement. In other words  what ever is defined in "Field" in chart properties will be displayed in current selection.

In qlikview usually it takes the Dimension from the expression even though if it has calculated dimension. Perhaps you have to raise this as a future enhancement with Qlik.

[rwunderlich]

You can fix this by wrapping the dimension expression in an aggr(). See

Scoping Selections with Aggr() | Qlikview Cookbook

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[phaneendra_kunc]

You are right Rob.

Use something like this.,.

=aggr(if(Dim1='A','A','All Other'),Dim1)