Solved: Re:Problem about sorting in straight table - Qlik Community

senpradip007 · ‎2013-01-16

Hi Experts

This discussion may be easy to all of you as I'm new in QlikView.

I have sorted this straight table Forcast wise and interactive sort is disabled. Still the table is sorted by dimension ie Category which is cyclic.

Please help me to get rid of this problem.

Thanks in advanced

PRADIP SEN

Anonymous · ‎2013-01-16

Hi There,

You should use Forcast (field or the expression which calculate it) in the sort order of the fields in your cycle group.

To do this go to the tab Groups in your Document properties (settings) Select your cycle group en click the Edit button.

Now select one field and the click Sort Order button. In the next screen you can select Expression and fill in any expression you want for any field you want.

Hope this is what you are looking for.

Good Luck,

Dennis.

View solution in original post

Anonymous · ‎2013-01-16

Hi There,

You should use Forcast (field or the expression which calculate it) in the sort order of the fields in your cycle group.

To do this go to the tab Groups in your Document properties (settings) Select your cycle group en click the Edit button.

Now select one field and the click Sort Order button. In the next screen you can select Expression and fill in any expression you want for any field you want.

Hope this is what you are looking for.

Good Luck,

Dennis.

senpradip007 · ‎2013-01-17

Hi Dennis,

Thanks for the suggetion.

Regards

Pradip