topic Does Authentication setting of QV Web Server affect Macro running properly? in QlikView

QVW INSIDE~Does Authentication setting of QV Web Server affect Macro running properly?

Tue, 01 Mar 2011 06:28:25 GMT

Does Authentication setting of QV Web Server affect Macro running properly?

If Authentication setting is Always, the macro below is good working. If 'Never', the macro is not working well.

my macro:

sub getCompanyMoneyCityRank
 set chart = ActiveDocument.GetSheet(0).CreateStraightTable '?????
 chart.AddDimension "=if(aggr(Sum ({$<???={$(V_CITYNAME)},??????=>}??),??????)>=t,??????)" '??t???????????????
 chart.AddExpression "Sum ({$<???={$(V_CITYNAME)},??????=>}??)" '??????????
 set cp = chart.GetProperties
 set dims = cp.Dimensions
 dims(0).NullSuppression = true '?????
 chart.SetProperties cp
 count = chart.GetRowCount-2 '????????????????????count
 call UpdateVarValue("V_Company_Money_CITY_RANK",count) '?count??????V_Company_Money_CITY_RANK
 chart.close
end sub

Does Authentication setting of QV Web Server affect Macro running properly?

Tue, 01 Mar 2011 08:16:07 GMT

Can any one guide me? thanks again

Does Authentication setting of QV Web Server affect Macro running properly?

Wed, 02 Mar 2011 06:12:15 GMT

Hi, here is the simple qvw file which is not working well with Authentiaction Setting set 'Never'.

Does Authentication setting of QV Web Server affect Macro running properly?

Anonymous — Wed, 02 Mar 2011 07:29:01 GMT

My guess would be that when you access a document anonymously, you're not allowed to create a chart using the macro since you need to be authenticated to create a collaboration object on the server. When you have authentication active, QVS can properly attach that object to the authenticated user.

Does Authentication setting of QV Web Server affect Macro running properly?

Thu, 03 Mar 2011 03:10:25 GMT

Hi,

Can I do something which can solve this problem?

Does Authentication setting of QV Web Server affect Macro running properly?

Anonymous — Thu, 03 Mar 2011 03:53:52 GMT

Well.. yes.

First of all I'm not sure why you want to run a macro to create a chart?

It doesn't make much sense to me to run a macro to let each used create an identical collaboration object on the server. If you want the object in the document, I would add it in the actual document layout.

This part just creates the same Straight Table over and over:

set chart = ActiveDocument.GetSheet(0).CreateStraightTable
chart.AddDimension "=Month"
chart.AddExpression "Sum (Amount)"
set cp = chart.GetProperties
set dims = cp.Dimensions
dims(0).NullSuppression = true
chart.SetProperties cp

Does Authentication setting of QV Web Server affect Macro running properly?

Thu, 03 Mar 2011 06:48:52 GMT

Hi,

I think there are several reasons why I run a macro to create a chart :

1, I want to calculate the rank of the DeptX in ScoreY. For example, assume there are a table. The DeptId and ScoreY are input by user from input box. And the ScoreY could from Score1 to Score99999.

2, I have a number of objects in the sheet. I worried about the performance if there are so many tables in the sheet even we can hide them.

3, I want to show ALL of the DeptId in the sheet. So I can't select a DeptId in the sheet to avoid only show one dept's information.

4, The table is not the static table in the database, it is dynamic created depands on user's select in the other sheet. So I can't use RANK funtion.

DeptId	ScoreA	ScoreB	ScoreC
dept1	76	45	34
dept2	75	54	76
dept3	45	98	75
dept4	54	34	76
dept5	98	76	75
dept6	34	75	45
dept7	23	45	54
dept8	23	45	34
dept9	44	54	32
dept10	78	98	75

So I think maybe I can dynamic create a chart by user demand to calculate the rank. It is better than add dozens of opjects in the actual document layout.

And what's more, I want to make myself clear

Does Authentication setting of QV Web Server affect Macro running properly?

Anonymous — Thu, 03 Mar 2011 07:04:56 GMT

Thanks for the long description. I'm still unclear of why the macro usage though. Also I'm not certain how this new description relates to the old example file provided.

Could you provide an example file with regards to the departments, and a step by step possible user input, and what you'd expect to see. I'm fairly certain you could create one dynamic chart that let's you show the values you want to see without the use of macros.

Does Authentication setting of QV Web Server affect Macro running properly?

Thu, 03 Mar 2011 08:53:03 GMT

Hi,

Thank you for your reply. It's a good question, The discription does no relate to the old exmple. But it is difficlut for me to tell the relattion clearly. Because my real data ,script and all object name(property) are edit in Chinese charactor. So in my early post, I tried to simple the question in English with an assumptive example. And make you confused.

Give me a little time to translate...