Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please... somebody help me!!!
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.