topic Re: sort data based on calculated dimension in QlikView

sort data based on calculated dimension

QSense — Mon, 04 Feb 2013 06:28:47 GMT

Hello everyone,

I have created a calculated dimension and ı wanna sort data according to this expression

my example

0-500 points

500-1000 points (these are results of dimension)

Thanks

er_mohit — Mon, 04 Feb 2013 06:33:49 GMT

hiiiii

in right click on your sheet object in properties--> sort tab there you check the numeric value asccending order

either you can sorting the value in script level.. for this you have load your table then the use group by function for sorting purpose

hope it helps

khadeer — Mon, 04 Feb 2013 06:34:17 GMT

Go to sort tab,

Select ur caluculated dimension and use sort options based on requirement.

Mon, 04 Feb 2013 07:10:03 GMT

sorting at script label:
order By name asc ;

object iproperties

sort tab --->check numeric value in asccending order

QSense — Mon, 04 Feb 2013 07:20:44 GMT

Thanks for replies ,

but it didnt work maybe if I give dimension

Could you give alternative solution?

if(Field>0 and Field<=500,'0-500 point,
if(Field>500 and Field_PUAN

<=1000,'500-1000 point, ))

Thanks

er_mohit — Mon, 04 Feb 2013 07:39:27 GMT

in dimension tab set your field as

=class(aggr(Sum(Field),Field_PAUN),vRange, 'n')

here vRange is variable that assigned to max value for one axis

like if yo want to display data with 2 values that set it to 500

or either in splitting form then set to 100

then range become 0<=n<100,100<=n<200..........1000

QSense — Mon, 04 Feb 2013 09:17:09 GMT

Thanks After I try , I will share ur solution is proper or not for my case:)