Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

santhoshkasam09
New Contributor III

Applying Bold letters in Pivot table with expression

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

3 Replies

Re: Applying Bold letters in Pivot table with expression

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: Applying Bold letters in Pivot table with expression

Hi Santosh,

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

S.

gavinigovind452
New Contributor II

Re: Applying Bold letters in Pivot table with expression

untick supress zero-values in Presentation tab and check it