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

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

marcus_malinow — Tue, 18 Mar 2014 11:47:07 GMT

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

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

bgerchikov — Tue, 18 Mar 2014 18:38:30 GMT

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!

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

marcus_malinow — Wed, 19 Mar 2014 10:35:47 GMT

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

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

bgerchikov — Wed, 19 Mar 2014 14:16:34 GMT

Hi Marcus,

Please review attached.

Thanks!

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

marcus_malinow — Wed, 19 Mar 2014 21:38:40 GMT

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