Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
santhoshkasam09
Contributor III
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
Anil_Babu_Samineni

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
simospa
Partner - Specialist
Partner - Specialist

Hi Santosh,

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

S.

gavinigovind452
Partner - Contributor II
Partner - Contributor II

untick supress zero-values in Presentation tab and check it