I am trying to color alternate rows in QlikSense by creating a dummy dimension using below function command:
=RowNo(TOTAL)
and putting a background color condition in all the columns as below
if(mod(rowno(total),2)=0, '#ebebeb')
This works perfectly fine and colors all the alternate rows.
With this logic I can sort my table on the basis of all the dimensions but when I use a measure for sorting, it does not work at all.
I read similar questions on the community which did tell that using RowNo() interferes with the sorting functionality.
Still I am reaching out to the community of there is some hack to solve this problem.
Can someone please help me on this ?
Thanks in advance.
Environment: Qlik Sense Enterprise Client Managed for Windows
Version: QlikSense May 2023
