Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vireshkolagimat
Contributor II

conditional formatting

Hi Guys,

I have below sample data and i need to make certain rows bold based on the row dimension description.


Dimension
Sales1Sales2
laptop

2

7
Printer64
Desktop23
Total1014

If dimension is Printer, then i need that Printer row should be highlighted in bold. and also the total row should be in bold.

Kindly let me know if we can achieve this.

Regards,

Viresh

14 Replies

Re: conditional formatting

Go to Dimension Tab

Click on + Sign of Dimension

Text Format

Write below

IF(Dimension= 'Printer','<b>')

Re: conditional formatting

Isn't the Total row already bold? I thought I remember seeing it bold

Re: conditional formatting

Go to Dimension Tab

Click on + Sign of Dimension

In Text Format put below expression

IF(Dimension= 'Printer','<b>')

Sames expression you need to write in both sales1 and sales2 expression Text format

Re: conditional formatting

Seems like it

Straight table

Capture.PNG

Pivot table

Capture.PNG

Re: conditional formatting

Oye Manish ka copy paste karta hai

Re: conditional formatting

Ha to itna type karte kon bethega.. or extra bhi dala he na.

Re: conditional formatting

yeh hua na honest chor

Re: conditional formatting

Imandari hi to humari pehchan he

vireshkolagimat
Contributor II

Re: conditional formatting

Hey, thanks it is working. How to compare the multiple line items in the same expression.

I tried the below expression but not getting the result as expected.

IF(Dimension= Match(Dimension,'Printers','laptop'),'<b>')

let me know if this can be possible.

Regards,

viresh

Community Browser