topic Changing expresions Style in QlikView

Changing expresions Style

Wed, 09 Feb 2011 00:54:50 GMT

Dear Guru,

I need to change the Labels style in my pivot table based on an expresion. So I put the expresion in the Text Color and Text Format (Grey and Italic) in the popup menu. It work fine, but if the first data line is changed, the labels of the expresion column change also.

How can I do That without affecting the labels of my expresions?

Thanks in advance,

Patrick

Changing expresions Style

Wed, 09 Feb 2011 05:03:29 GMT

Hi Patrick,

I faced the same issue earlier in my previous assignment and what I did is,

I added a partial sum for the very first dimention and set the option to show total on top.

then modified the expressions to check the dimensionality and calculate accordingly.

You can also try the same. I am sure this will help you.

Thanks & Best Regards,

Kuldeep Tak

Changing expresions Style

Wed, 09 Feb 2011 15:57:19 GMT

Thanks Kuldeep, it works. Good tip.

Patrick