Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

Show Label instead of Formula on the Header

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?

check.png

10 Replies
pooja_sn
Contributor

Re: Show Label instead of Formula on the Header

Assign a label to your expression.

vishsaggi
Esteemed Contributor III

Re: Show Label instead of Formula on the Header

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
Valued Contributor III

Re: Show Label instead of Formula on the Header

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

rammuthiah
Contributor II

Re: Show Label instead of Formula on the Header

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.

Community Manager
Community Manager

Re: Show Label instead of Formula on the Header

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
Contributor II

Re: Show Label instead of Formula on the Header

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

phaneendra_kunc
Valued Contributor III

Re: Show Label instead of Formula on the Header

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.

7-15-2016 10-07-15 AM.png7-15-2016 10-07-48 AM.png

Re: Show Label instead of Formula on the Header

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
Valued Contributor III

Re: Show Label instead of Formula on the Header

You are right Rob.

Use something like this.,.

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