topic Pivot table label missing for expression in QlikView

Pivot table label missing for expression

Wed, 25 Mar 2015 07:38:10 GMT

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

Re: Pivot table label missing for expression

giakoum — Wed, 25 Mar 2015 07:41:19 GMT

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

Re: Pivot table label missing for expression

Wed, 25 Mar 2015 09:48:08 GMT

Hi,

PFA Sample app and data.

BR,

Neeru

Re: Pivot table label missing for expression

Mon, 30 Mar 2015 02:14:09 GMT

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

Re: Pivot table label missing for expression

giakoum — Mon, 30 Mar 2015 07:41:56 GMT

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.

Re: Pivot table label missing for expression

Tue, 31 Mar 2015 02:04:09 GMT

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

Re: Pivot table label missing for expression

giakoum — Tue, 31 Mar 2015 10:42:54 GMT

http://community.qlik.com/message/353335#353335

Re: Pivot table label missing for expression

rubenmarin — Tue, 31 Mar 2015 10:50:51 GMT

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