topic Re: Text format in pivot table in QlikView

Text format in pivot table

Anonymous — Wed, 01 Jun 2016 11:16:28 GMT

Hi,

I want to change the text format in a pivot table into bold. What I see is that the text only turns into bold when there is data in the first line under the text. Any idea as to what might be causing this ?

Re: Text format in pivot table

sunny_talwar — Wed, 01 Jun 2016 13:32:55 GMT

Can you try unchecking 'Suppress Zero Values' on the presentation tab?

Re: Text format in pivot table

Anonymous — Wed, 01 Jun 2016 13:39:43 GMT

Hi Sunny,

Thanks for your reply.

This is something I have tested before, but I want to avoid it, because the end users want to see only rows where there is at least one value that is greater than zero. The rest is just overhead.

Re: Text format in pivot table

Anonymous — Wed, 01 Jun 2016 15:02:00 GMT

Hi Filip,

You can do it with cell format.

Show design grid
Right clic on object and select custom format cell

Regards!

Re: Text format in pivot table

sunny_talwar — Wed, 01 Jun 2016 15:42:29 GMT

Would you be able to share a sample to play around with?

Re: Text format in pivot table

Anonymous — Mon, 06 Jun 2016 06:43:07 GMT

Hi Sunny,

I have attached an example.

Regards,

Filip

Re: Text format in pivot table

sunny_talwar — Mon, 06 Jun 2016 12:50:28 GMT

Try this expression:

=If(Sum(TOTAL <Operation> LocationInv) > 0 and Sum(TOTAL <ProductNr> LocationInv) > 0, Dual(Alt(If(Sum(LocationInv) > 0, Sum(LocationInv)), '- -'), If(Sum(LocationInv) = 0, 0.01, Sum(LocationInv))))

Re: Text format in pivot table

Anonymous — Mon, 06 Jun 2016 14:00:23 GMT

Hi Sunny,

Works perfectly. Thanks for your help.

Regards,

Filip

Re: Text format in pivot table

sunny_talwar — Mon, 06 Jun 2016 14:40:57 GMT

Not a problem my friend