Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Moore
Former Employee
Former Employee

Financial highlighting - in pivot table

I am trying to get this highlighted effect in QV:

target.png

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

Any ideas?

Thanks!

1 Solution

Accepted Solutions
Daniel_Moore
Former Employee
Former Employee
Author

I had success using the RowNo() function:

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


customFormat.png


Much more readable.



View solution in original post

3 Replies
vivek_niti
Partner - Creator
Partner - Creator

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
Former Employee
Former Employee
Author

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

Daniel_Moore
Former Employee
Former Employee
Author

I had success using the RowNo() function:

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


customFormat.png


Much more readable.