Discussion board where members can get started with Qlik Sense.
I have a straight table with this condition for background color in measures:
If I use this formula for background cell color, tables looks ok but I can't order by headers:
Whitout this expression for color works fine, why? How Can I solve it?
Go to Solution.
Unfortunately, I don't think we have any other option
but try below, if you have only one dimension, replace Dim3 with your ActualFieldname
Rowno() is an inter-record function so you won't be able to sort by headers
You need to use Sort by Expression
Thanks you Vineeth, is more important the possibilty of order by header than the color... Do you know if there is a way to get this kind of table color (alternating colors) without use the rowno() function?
Thanks you so much again
It works fine but when you order by val lost the color alternate dinamic, thakns you for all!