topic sort by colomn name in QlikView

sort by colomn name

Tue, 28 Jun 2011 15:48:23 GMT

Hello Experts

I need a small help regarding a macro ... I'm creating a trigger to sort by a specified colomn in a chart but in this case i want to use colomn names instead of using colomn no.'s as SortBy 0 / SortBy 1

so is there any way that i can sort by colomn name in a macro .

Here is the sample code of my macro that how i wrote ...

set chart1 = ActiveDocument.GetSheetObject("CH01")

chart1.SortBy 0

set chart1 = ActiveDocument.GetSheetObject("CH02")

chart1.SortBy 2

Thanking u all

Meher

Re: sort by colomn name

IAMDV — Tue, 28 Jun 2011 16:07:21 GMT

Hi Meher,

Instead of using macro why don't you use variable? I mean you can sort by expression and then use the triggers to set the expression in the variable which will sort your expression.

For example :

I am using $(vChartSorting) variable in the sort by expression for the chart object. And then actions of button click event I am setting the variable value as SUM(Amount)/Count(ID) for vChartSorting variable.

I hope this helps!

Cheers - DV

sort by colomn name

Tue, 28 Jun 2011 23:14:37 GMT

Thanks for reply DV

but can you explain a litle bit briefly may be with some sample QVW's which helps me a lot ...

thanks

Meher

Re: sort by colomn name

IAMDV — Wed, 29 Jun 2011 07:46:59 GMT

Hi Meher,

You are welcome. Sure, but can you please post your sample QV document? And also give more details on how you wanted to sort the data. I can work an example from your data.

Cheers - DV

Re: sort by colomn name

IAMDV — Thu, 30 Jun 2011 13:54:12 GMT

Hi Meher,

Have you got this working? or do you need more help on this post?If yes, then please post the sample QV document with more explanation on what you wanted to achieve.

Good luck!

Cheers - DV

sort by colomn name

Tue, 05 Jul 2011 19:44:35 GMT

Hi DV

Sorry for replying late ...

that issue was solved for me thanx for your help

Meher