Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

marcus_malinow
Valued Contributor 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
Contributor III

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

Hi Marcus,

Please review attached.

Thanks!

4 Replies
bgerchikov
Contributor III

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

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
Valued Contributor III

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

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
Contributor III

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

Hi Marcus,

Please review attached.

Thanks!

marcus_malinow
Valued Contributor III

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

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

Community Browser