topic sorting on excluded value in QlikView

sorting on excluded value

sijojoseph22 — Tue, 07 Apr 2015 20:43:48 GMT

Hi All,

We are using the match function Match([Fleet Value USD Band], '0-1m','1-5m','5-10m','10-25m','25-50m','50-100m','>100m') in the expression to do the sorting.

Also we are using set analaysis in the expression and and because of that the value '>100m' is greyed out and sorting not working.

Is there any option to include to correct sorting order.

Thanks,
Sijo

Re: sorting on excluded value

Anonymous — Tue, 07 Apr 2015 20:53:45 GMT

Is it possible to upload a sample file?

Re: sorting on excluded value

Tue, 07 Apr 2015 21:30:03 GMT

With an example it would be easier to help you out.

Re: sorting on excluded value

sijojoseph22 — Tue, 28 Apr 2015 08:19:27 GMT

Hi All,

Thanks for the reply, we have solved by creating a inline table with the required banding values before the data loads. And joined with the banding and given the default load order in the sort order by giving the inline table field as dimension. This has solved by issue.

Regards,

Sijo