Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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
Partner
Partner

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

Not applicable

Hi,

PFA Sample app and data.

BR,

Neeru

Not applicable

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

Partner
Partner

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

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

Partner
Partner

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))