Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
erieqlik
Contributor III
Contributor III

I want alternating row colors in a table based on the values in a column

I am using Qlik Sense.

Here is my test data, in reality I have many more columns.

TestData:
LOAD * inline [
Series|Series#|Title|Pages
Lumpy Stories|1|Lumpy Get's His Name|34
Three Body Problem|1|The Three-Body Problem|401
Lumpy Stories|2|Lumpy Goes to Jail|93
Harry Potter|2|Philosopher's Stone|375
Harry Potter|2|Chamber of Secrets|299
Harry Potter|3|Prisoner of Azkaban|354
Harry Potter|4|Goblet of Fire|654
Harry Potter|5|Order of the Phoenix|423
Three Body Problem|2|The Dark Forest|465
Three Body Problem|3|Darth's End|396
Harry Potter|6|Half-Blood Prince|298
Harry Potter|7|Darthly Hallows|651
] (delimiter is '|');

My table widget will be sorted by Series. For each Series grouping I want a color for the background. Example grouping.jpg

I was successful in doing it with a series of measures but I do not want my formula measures on display and when I hide them everything stops working. It should be as simple as checking ABOVE but I need to keep track of what row I am on as well. It all needs to be in the expression for background.

Additionally, I would like to have another measure to the left of Series that is the sequence, the first Series would show a 1, the second Series would show a 2, and so on (they would repeat and I would hide the successors by changing the text color).

Thoughts?

Labels (2)
0 Replies