Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find the attached app.
I am using a straight table with 3 dimensions and 2 expressions. One of my dimensions [Party Name] is a calculated dimension.
From Help files of QlikView, I understood that Above() function work by the sort order in 'Sort' tab.
My desired sort order is: Name of the state -> Parliamentary Constituency -> Total Votes Polled -> Party Name -> Incremental.
'Incremental' is the column where I am using above() function. But this is not following the sort order I mentioned above.
Just a point, adding TOTAL does not help either.