Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interactive sort not working when using RowNo() for coloring alternative rows in straight table

Hi i am using  "if(Odd(RowNo()),ARGB(96,96,96,96))" expression to color alternate  rows in straight table.My straight table contains 2 columns.But when iam using this expression in each column to color the alternative rows, the interactive sort is not working and when i delete this expression the sorting works fine.

6 Replies
tresesco
MVP
MVP

Yes, it's something by-design.

Help says:

Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when Chart Inter Record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.

 

Not applicable

Hey,

In my case it is working.

I followed below steps:

Used Straight table and took one expression SUM([Employee_Count] and one dimension Department_ID

Checked Interactive Sorting option.

Then Clicked on Expressions Tab-->Expended and added expression if(Odd(RowNo()),ARGB(96,96,96,96)) under Background Color

Then clicked on Dimensions Tab-->Used Dimension-->Background Colol--> Edit--> added expression if(Odd(RowNo()),ARGB(96,96,96,96)).

It is working without any issue.

Capture.PNGCapture 1.PNG

jonathandienst

If you use an interrecord function like RowNo(), you can sort the dimension(s), but not the expressions. If you click on Sum in your example, it will not sort the values.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

ShivendookumarHi below attached a sample qlikview file,i have tested again but the result is same,no interactive sort


Not applicable

Hi Ryan,

Just go to Sorting Tab-->Promote Country on top and then Interactive sorting Icon will appear to Country column and It will work.

Note: As mentioned by Jonathan, Interactive Sorting does not work on column added under Tab Expressions.

Your Clicks column is under Expressions tab and in Sorting tab Clicks column was on top and that's Y it was not working.

Please find the attached qvw (Working)

dennisnet
Partner
Partner

How come, when I add dimensions, the colours dont change every other row any more?

It seems to be random. Any suggestions on how to fix this?

Knipsel.PNG