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: 
senpradip007
Specialist III
Specialist III

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

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

2 Replies
Anonymous
Not applicable

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
Specialist III
Specialist III
Author

Hi Dennis,

Thanks for the suggetion.

Regards

Pradip