topic Re: Strange behaviour in text format on a pivot table in QlikView

Strange behaviour in text format on a pivot table

canmarroig — Wed, 12 Feb 2014 08:51:48 GMT

I've a pivot and i've formatted text on dimension 'month' (this is a cycle dimension) with ='<b>' and starting form 'june' it doesn't format text anymore, is there a workaround? Tks

Re: Strange behaviour in text format on a pivot table

Michiel_QV_Fan — Wed, 12 Feb 2014 09:10:16 GMT

Is it the same field. I see an april date (29/04/213) right under mag.

Re: Strange behaviour in text format on a pivot table

canmarroig — Wed, 12 Feb 2014 09:14:29 GMT

This is a week start (the first of mag) but this is not my trouble.

Re: Strange behaviour in text format on a pivot table

Michiel_QV_Fan — Wed, 12 Feb 2014 10:14:27 GMT

Is it possible to post your QlikView application?

Re: Strange behaviour in text format on a pivot table

canmarroig — Wed, 12 Feb 2014 10:27:32 GMT

No, i can't, but i've checked that if I substitute cycle field with only 1 dimension, bold text works perfectly also on june, may, etc. Also substituting cycle field with a drill-down dimension. Very strange

Re: Strange behaviour in text format on a pivot table

Michiel_QV_Fan — Wed, 12 Feb 2014 10:41:23 GMT

Strange indeed. I hope someone else has the answer.

Re: Strange behaviour in text format on a pivot table

sudeepkm — Wed, 12 Feb 2014 12:26:40 GMT

Have you tried Custom Formatting. Using custom formatting you can make the whole dimension values as bold.

Re: Strange behaviour in text format on a pivot table

canmarroig — Thu, 13 Feb 2014 08:40:19 GMT

I can't see this menu when i click. My custom formatting options are only inside Properties.

Re: Strange behaviour in text format on a pivot table

sudeepkm — Thu, 13 Feb 2014 08:49:09 GMT

Can you please enable Grid mode then right click on the Straight or Pivot table.

Maybe then you can see Custom Format option.