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