topic Sorting by expression in web-version in QlikView

Sorting by expression in web-version

Tue, 14 Dec 2010 09:31:40 GMT

Im use graph with one expression sum(sale), and one dimension vDim01 (it's variable, i set there some dimensions by klick on button).

Variable can take few dimensions, like Year, Month, Region, Emp, ....

When dimension is Year or Month, a need to sort by default, when other - by sum(sale), and i do it by sort expression:

if(vDim01 like 'Month' or vDim01 like 'Year' , vDim01,sum(sale))

It work fine in QlikView BUT it don't work in web version, it always sort by default.

My question is WHY it don't sort in web, and what solution is to solve my problem.

QV Personal Edition 9.0

IE 8, Mozilla, Opera

Thank for answers

Regards,

Igor

Tue, 14 Dec 2010 16:25:37 GMT

Please... somebody help me!!!

Fri, 17 Dec 2010 16:07:09 GMT

Normal 0 false false false RU X-NONE X-NONE MicrosoftInternetExplorer4

Thanks to all!

You really help me…

If somebody will be interesting how it's solve, I find solution, that work in Web, and that what I need in my case.

First, in graph set sort by text, next

On buttons, that set values to variable vDim01, just add macros like this:

To other dimensions, not like "Month" or "Year"

sub sortXY

set chart = ActiveDocument.GetSheetObject("CH03")

set p = chart.GetProperties

p.SortByYValue = -1

chart.SetProperties p

end sub

To dimensions "Year" and "Month"

sub sortTXT

set chart = ActiveDocument.GetSheetObject("CH03")

set p = chart.GetProperties

p.SortByYValue = 0

chart.SetProperties p

end sub

It really work in web version.

I hope it will helpful.