Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Dynamic table - set default sort order based on conditionally displayed expressions

Hi,

I've run into an issue with the sort order in a straight table.

I have several dimensions, and several conditionally displayed expressions. The condition for the display of these is based on the users' selection of a field in a data island.

My issue is that I set the sort order priority to these expressions, however it seems to be reset every time I open the document, and the priority reverts to the dimensions first, then whichever expressions are enabled.

Does anyone know of a fix for this?

Marcus

1 Solution

Accepted Solutions
bgerchikov
Partner - Creator III
Partner - Creator III

Hi Marcus,

Please review attached.

Thanks!

View solution in original post

4 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

Hi Marcus,

You might need to use Expression option in Chart tab with the multiple IF...ELSE conditions since you're using data island to show/hide columns.

Can you post a sample?

Thanks!

marcus_malinow
Partner - Specialist III
Partner - Specialist III
Author

Hi Boris,

I've attached an example. In this, I'd like the sort order priority to default to 'Sales Value' descending, however it seems that the sort order priority is reset when the selections in the Dimension and Measure fields are cleared.

Marcus

bgerchikov
Partner - Creator III
Partner - Creator III

Hi Marcus,

Please review attached.

Thanks!

marcus_malinow
Partner - Specialist III
Partner - Specialist III
Author

Hi Boris,

thanks for this - will give this a go with a small variation - an additional calculated dimension to use as the sort order so that I can still sort on the existing dimensions.

Marcus