Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

senpradip007
Not applicable

Re:Problem about sorting in straight table

Hi Experts

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

Untitled.png

     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

1 Solution

Accepted Solutions
dennisnet
Not applicable

Re:Problem about sorting in straight table

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.

2 Replies
dennisnet
Not applicable

Re:Problem about sorting in straight table

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
Not applicable

Re:Problem about sorting in straight table

Hi Dennis,

Thanks for the suggetion.

Regards

Pradip