topic Re: How to Apply Background Color for Empty Fields in Pivot Table in QlikView

How to Apply Background Color for Empty Fields in Pivot Table

hariprasadqv — Fri, 21 Aug 2015 04:07:27 GMT

Hi All,

How can we Apply Background color for Empty Cells in Pivot Table. cell's may contain Text or Numaric value.

Thanks in Advance

sunny_talwar — Fri, 21 Aug 2015 04:13:14 GMT

May be using this kind of logic:

If(Len(Trim(YourExpression)) = 0, BackGroundColor, OtherColorWhereThereIsValue)

jsingh71 — Fri, 21 Aug 2015 04:52:44 GMT

if you want to do like below :

then see the attached qvw.

Anonymous — Fri, 21 Aug 2015 05:12:17 GMT

Hi Hari,

Please have a look:

Hope it helps!!

kkkumar82 — Fri, 21 Aug 2015 05:24:54 GMT

Hi,

Hi for the expression in the expressions tab (properties) click ' + ' and you get a tree , there you select the background

and a condition if(isnull(expression), rgb1(n1,n2,n3),rgb1(n1,n2,n3))

Thanks

Kiran Kumar

kkkumar82 — Fri, 21 Aug 2015 05:26:04 GMT

Hi,

Sorry for forgetting the same you can find for Dimensions also.

Thanks

Kiran Kumar