Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-05-09 04:22 AM

Pivot table color stripes

Can anyone help to get color stripe in pivot chart?

Some thing like this

Untitled.png

Thanks,

Ravi Shankar

sample.qvw
783 Views
0 Likes
4 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-05-09 04:51 AM

May be use this for all expressions

=if(Even(RowNo(TOTAL)), LightBlue(), Green())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
629 Views
0 Likes
kkkumar82
Specialist III
Specialist III
‎2017-05-09 04:58 AM

The Months columns in your sample are pivoted ?

629 Views
0 Likes
Not applicable
‎2017-05-09 08:20 AM
Author

In response to Anil_Babu_Samineni

This logic is not working

629 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-05-09 10:13 AM

In response to

Could be issue with Field Names for 3rd and 4th one. Can you remove that and try then We can look whether how we can achieve this?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
629 Views
0 Likes