Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Conditional formatting of cell borders in straight/Pivot table

Hi,

I have a straight table (Image attached). I want to have conditional cell borders. As want to show certain values only once for specific dimension values. I have tried using Custom Format Cell but somehow it's not working as per condition given. Please help.

3 Replies
Highlighted

Re: Conditional formatting of cell borders in straight/Pivot table

I don't think whether we have control of this? You may change it to BG color and cell border with same color when Condition is Zero like If condition. FYI Attached

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)
Highlighted
New Contributor III

Re: Conditional formatting of cell borders in straight/Pivot table

Thank you for your reply Anil. I think Custom Format Cell is should work that way as there's conditional expression. But it's not working. I wanted to show price 100 as 1 value for

 

Cycles
Gears
Helmate
Gloves

than 4 values & no border as shown in image attached so 100 would appear as a single value for products above.

This is specifically for export to excel.

Highlighted

Re: Conditional formatting of cell borders in straight/Pivot table

Like This?

Capture.PNG

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)