topic Re: Sorting Issue in Straight Table? in QlikView

Sorting Issue in Straight Table?

khajafareed — Sun, 02 Aug 2015 07:30:51 GMT

Hi All,

I have 400 plus Dimensions in my Straight Table. I am facing sorting issue in Straight Table, Sorting in the sense columns are not getting arranged in chart according to my selection.

Suppose i have dimension like Country, Address Line1, CSO Item Key, etc., If i select Country then CSO Item Key later Address Line1 Then i have to get result in Chart as i select but i am not getting respectively as my selections.

Please help me in this case.

Thanks,

Khaja Fareed

Re: Sorting Issue in Straight Table?

marcus_sommer — Sun, 02 Aug 2015 10:20:56 GMT

More as 400 dimensions in one object, even in one application - are you sure that you really choose those dimension for your selections which you are supposed to? Further you could have set analysis and/or alternate states within your objects which would influence the selection.

Honestly - I would rethink the whole application if there are not better and easier ways to reach your aims. Maybe you used at first the document analyzer which fields are really used: Document Analyzer V2 -- a major update.

- Marcus

Re: Sorting Issue in Straight Table?

ecolomer — Sun, 02 Aug 2015 10:49:45 GMT

Realy? 400 dimensions?? are you sure?

Re: Sorting Issue in Straight Table?

Anonymous — Sun, 02 Aug 2015 11:50:43 GMT

Hi,

I think 400 dimension in a straight table can do many problem.

Reanalyze the application.

Best regards.

Re: Sorting Issue in Straight Table?

khajafareed — Sun, 02 Aug 2015 14:46:49 GMT

Yup Guys, I have really 400 plus, any solution for this. Forget about 400 if there are are 15 to 20 dimensions how we can do sorting according to our selection.

Re: Sorting Issue in Straight Table?

Kushal_Chawda — Sun, 02 Aug 2015 14:51:27 GMT

can you share your sample app reducing data?

Re: Sorting Issue in Straight Table?

marcus_sommer — Sun, 02 Aug 2015 15:01:14 GMT

I'm not sure if it's the attempt worth to sort the straight-table in consideration from the order of user-selections then a column could be simply sorted by a double-click on the column-header. For anything else you would need quite complicated sort-expressions which queries each time the current-selection and compared it with the previous current selection and some things more. With many from such sort-expressions your table will be perform quite slow.

I couldn't see a real added value.

- Marcus

Re: Sorting Issue in Straight Table?

khajafareed — Sun, 02 Aug 2015 15:13:54 GMT

Re: Sorting Issue in Straight Table?

swuehl — Sun, 02 Aug 2015 15:20:31 GMT

Not sure if it's clear what your issue is.

Seems like you are using conditional dimensions and you want to promote / demote dimensions in the order they are selected in your dialog?

Or are you talking about the order of lines?

Re: Sorting Issue in Straight Table?

khajafareed — Sun, 02 Aug 2015 15:25:55 GMT

yup, absolutely i am using conditional dimensions. My issue is order of columns in straight table should be according to my selection.

Thanks,

Re: Sorting Issue in Straight Table?

marcus_sommer — Sun, 02 Aug 2015 15:42:59 GMT

For this you need to query the selections from your selection-field quite similar to above mentioned but instead of getcurrentselections you would use getfieldselections. But this would only work for selections which are made one after another - if the user makes multiple selections by draging several values with mouse or pressing the ctrl-key to get the selection-order would fail.

As alternatively you could build fix selection-structures with a field or variable for each dimension but I doubt that will be a real option for you.

- Marcus

Re: Sorting Issue in Straight Table?

qlikviewwizard — Mon, 03 Aug 2015 03:54:19 GMT

Hi,

1. It is really astonishing that you are using 400 + dimensions in your report.

2. Order the objects by demote and promote option ans save it.

Hope this will help you. Thank You.