topic Re: Straight table in QlikView

Straight table

Wed, 30 Apr 2014 07:43:19 GMT

Hi all,

I got a straight table with interactive sort and it's indeed possible to sort on everything.

However my average expressions will only sort one way and thats ascending. I would like to sort descending so does anybody got a clue why qlikview is rejecting this option?

kind regards,

Vincent

Re: Straight table

martinpohl — Wed, 30 Apr 2014 07:47:31 GMT

on the tab sort the interactice sort option is enabled?

sometimes it happens to me that qv don't reconized that i want to sort a column.

Then I go to the sort tab, set the column I want to sort manuel to the top and sort by numeric value

Regards

Re: Straight table

Wed, 30 Apr 2014 07:53:16 GMT

hmm doens't seem to work. Every other expressions is working on the sorting but only the expressions where I used the function: AVG. It won't work it just sorts ascending

Re: Straight table

Wed, 30 Apr 2014 11:43:54 GMT

anybody?

Re: Straight table

sudeepkm — Wed, 30 Apr 2014 11:53:15 GMT

what sort option you have in those expressions where you have avg.

is it possible for you to post sample qvw.

I tried in one of the my qvws and found it is working fine.

Re: Straight table

Wed, 30 Apr 2014 11:55:37 GMT

Solved it, apparently it doens't work in qlikview but the online version it just works fine..