topic Re: conditional formatting in QlikView

conditional formatting

vireshkolagimat — Fri, 01 Jul 2016 08:41:26 GMT

Hi Guys,

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

Dimension	Sales1	Sales2
laptop	2	7
Printer	6	4
Desktop	2	3
Total	10	14

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

Re: conditional formatting

MK_QSL — Fri, 01 Jul 2016 08:43:04 GMT

Go to Dimension Tab

Click on + Sign of Dimension

Text Format

Write below

IF(Dimension= 'Printer','')

Re: conditional formatting

sunny_talwar — Fri, 01 Jul 2016 08:44:56 GMT

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

Re: conditional formatting

Kushal_Chawda — Fri, 01 Jul 2016 08:46:46 GMT

Go to Dimension Tab

Click on + Sign of Dimension

In Text Format put below expression

IF(Dimension= 'Printer','')

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

Re: conditional formatting

sunny_talwar — Fri, 01 Jul 2016 08:47:22 GMT

Seems like it

Straight table

Pivot table

Re: conditional formatting

sunny_talwar — Fri, 01 Jul 2016 08:48:23 GMT

Oye Manish ka copy paste karta hai

Re: conditional formatting

Kushal_Chawda — Fri, 01 Jul 2016 08:50:01 GMT

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

Re: conditional formatting

sunny_talwar — Fri, 01 Jul 2016 08:50:29 GMT

yeh hua na honest chor

Re: conditional formatting

Kushal_Chawda — Fri, 01 Jul 2016 08:52:31 GMT

Imandari hi to humari pehchan he

Re: conditional formatting

vireshkolagimat — Fri, 01 Jul 2016 10:14:32 GMT

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'),'')

let me know if this can be possible.

Regards,

viresh

Re: conditional formatting

PrashantSangle — Fri, 01 Jul 2016 10:50:45 GMT

Hi,

try like

IF(Match(Dimension,'Printers','laptop'),'')

Regards

Re: conditional formatting

Peter_Cammaert — Fri, 01 Jul 2016 11:18:27 GMT

Wow, just discovered Google Translate. Works pretty well

Re: conditional formatting

vireshkolagimat — Fri, 01 Jul 2016 11:22:45 GMT

Thank you, it's working.

Re: conditional formatting

nilapril2010 — Fri, 01 Jul 2016 11:26:13 GMT

hi,

you can try with this code -

IF(Dimension='Printers' Or Dimension='laptop','')

Nilanjan

Re: conditional formatting

susovan — Fri, 01 Jul 2016 12:40:48 GMT

Hi Viresh,

You can also try this example,

if(GetSelectedCount(Dimension)>=1,'')