topic Re: Sorting Help in QlikView

Sorting Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have attache a sample application. Here my requirement goes like below.

1.When there is no selection (Clear All) my dimension needs to be sorted as a "A-Z"

2.When I am click "List" the pivot table needs to be sorted as per Id column which I implemented.

All I need is with out any selection I need to sort the columns in "A-Z" manner

-Jay

Re: Sorting Help

swuehl — Sun, 29 May 2016 16:06:52 GMT

Maybe like attached, using a sort expression like

=If(GetSelectedCount(Id), Ord(Rules),min(Sort))

Re: Sorting Help

Anonymous — Sun, 29 May 2016 16:39:40 GMT

Hi swuehl,

Thank you for your quick response.Your solution worked (almost ) when my Rules defined in Upper case(N). But when my Rules defined with Small case(n) it is not working.

Sorry for the inconvenience. I found this when I am testing with real data. Is there is any solution.

FYI,

Attached lower case scenario

-Jay

Re: Sorting Help

swuehl — Sun, 29 May 2016 16:45:30 GMT

Maybe like

=If(GetSelectedCount(Id), min(Sort),Ord(lower(Rules)))