topic Re: Applying Bold letters in Pivot table with expression in QlikView

Applying Bold letters in Pivot table with expression

santhoshkasam09 — Mon, 27 Aug 2018 05:06:44 GMT

Hi All,

I am trying to make only few values of a dimension as bold and else values as normal in a pivot table. But the condition in the expression is getting affected only if the dimension is having value in measure. Else in is not getting effected.

For example:

The dimension values are Pens, Pencils and Erasers. And measures is Count of those items sold by month.Now i am displaying in the below format:

| Count of Items sold

____|__________________________

Item | Jan 2018 Feb 2018 Mar 2018

---------------------------------------------------

Now for Pencils i dont have any values for Jan 2018 due to which Erasers is not becoming bold even if it has values in Feb and Mar.

Can anyone help me please? Thanks in advance!!

Regards

Santhosh Kasam

Re: Applying Bold letters in Pivot table with expression

Anil_Babu_Samineni — Mon, 27 Aug 2018 06:58:00 GMT

santhosh kasam wrote:

Now for Pencils i dont have any values for Jan 2018 due to which Erasers is not becoming bold even if it has values in Feb and Mar.

Can you explain little more for highlighted one?

Re: Applying Bold letters in Pivot table with expression

simospa — Mon, 27 Aug 2018 08:17:53 GMT

Hi Santosh,

please can you attach a sample .qvw or a printscreen so we can better undestand and help you?

Re: Applying Bold letters in Pivot table with expression

gavinigovind452 — Tue, 28 Aug 2018 11:35:42 GMT

untick supress zero-values in Presentation tab and check it