Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table label missing for expression


Dear Gurus,

I have made a pivot table with one expression and 5 dimensions. out of 5 dimensions i brought 2 dimensions as columns. Then my Expression label is missing.

If I do the same with 2 expressions(clacualtions) I can see labels.

Pls let me know how can I see the label if I have only one expression. Is it a limitation?

Please see the screenshots.

BR,

Neeru

Pivot Table One expression.JPGPivot Table two expressions.JPG

7 Replies
giakoum
Partner - Master II
Partner - Master II

can you post a sample app? Not happening for me.

Not applicable
Author

Hi,

PFA Sample app and data.

BR,

Neeru

Not applicable
Author

Does any one has the solution for this issue? pls help

giakoum
Partner - Master II
Partner - Master II

The only thing I came up with is creating a dummy 2nd expression and setting the width to 0 so it does not show. You will need a macro to set the width to zero.

But why is it so important? Since it is one expression, you can put the description in the charts caption.

Not applicable
Author

Hi Jonnis,

My expressions are dynamic based on user selection(in List Box) I will show only one expression at a time.

I tried with the second dummy expression early but wasn't able to hide it.

Kindly share the macro to set width to 0 of my dummy expression.

BR,

Neeru

rubenmarin

Hi Neeru, not tested and I don't know how it will affect performance but you can try to add a calculated dimension after day, ie:

=$(=Chr(39) & SelectedExpressionField & Chr(39))