topic Financial highlighting - in pivot table in QlikView

Financial highlighting - in pivot table

Daniel_Moore — Tue, 30 Jun 2015 02:58:43 GMT

I am trying to get this highlighted effect in QV:

The closest I could get was in this QVW....

Any ideas?

Thanks!

vivek_niti — Tue, 30 Jun 2015 05:08:35 GMT

Hi,

Please find the attached file.

Step1: Enable the Design Grid.

Step 2: Go to Custom Format cell by going into the properties drop down of the chart

Daniel_Moore — Tue, 30 Jun 2015 15:38:44 GMT

Did you mean to send a new file? It looks the same to me as the one I originally posted?

Daniel_Moore — Tue, 30 Jun 2015 15:44:14 GMT

I had success using the RowNo() function:

=If(Even(RowNo(TOTAL)), RGB(255, 255, 255), RGB(204,204,204))

Much more readable.