topic Re: sort in QlikView

sort

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

Hi Experts,

I have one straight table with

dim: add calculated dimension

expression is :

sum(value)

count(number)

sum(cost)

count(distinct id)

when I do sorting , it is not happening but if I disable the 4th expression sorting is working why?

any reason behind this

here my dimension and id are from 2 different tables .

but there is a association with different fields /

Anil_Babu_Samineni — Thu, 01 Dec 2016 05:35:07 GMT

Sort is not working? What was that sorts keys

Can we know those result expecting by screen shots

jonathandienst — Thu, 01 Dec 2016 05:50:19 GMT

I have seen a problem before withe sorting not working with a "distinct"...

Anonymous — Thu, 01 Dec 2016 06:02:58 GMT

Hi Folks ,

I got the solution

rowno() function has been used in background color expression, which is not allowing for sort

commented that code tested ,its working now

Thanks all