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.
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).