topic Re:Problem about sorting in straight table in QlikView

Re:Problem about sorting in straight table

senpradip007 — Wed, 16 Jan 2013 12:10:17 GMT

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

Re:Problem about sorting in straight table

Anonymous — Wed, 16 Jan 2013 14:28:50 GMT

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.

Re:Problem about sorting in straight table

senpradip007 — Thu, 17 Jan 2013 06:12:05 GMT

Hi Dennis,

Thanks for the suggetion.

Regards

Pradip