topic Re: addDimension in Macro in QlikView

addDimension in Macro

Thu, 11 Dec 2014 15:30:38 GMT

Hello Experts,

I have a question for macro.

My customer is developing a macro like the followings.

sub sortingEquipTrendChart(equips)
chartX = 639
chartY = 128
orignX = 0
orignY = chartY
flg = 0
objs = ActiveDocument.ActiveSheet.GetSheetObjects
for i=lbound(objs) to ubound(objs)
if objs(i).GetObjectType = 12 then .
   dimen = "=if(EQ_ID='" & equips(flg) & "',EQ_ID)"
   objs(i).RemoveDimension 0
   objs(i).RemoveDimension 0
   objs(i).AddDimension(dimen)   --> It doesn't work.
   objs(i).AddDimension("STS2_SEQ") --> OK, It works fine.
   set pos = objs(i).GetRect
   if flg<>0 then
    orignY = orignY + (pos.Height - 1)
   end if
   pos.Top = orignY
   objs(i).SetRect pos
      set pos = nothing
      flg = flg + 1
end if
next
end sub

But he want to know it is possible to use 'addDimension' with a parameter including expression like "=if(EQ_ID='" & equips(flg) & "',EQ_ID)".

Is it possible ?

Need your recommendation.

Thanks ,

WanKi,

Re: addDimension in Macro

pljsoftware — Thu, 11 Dec 2014 15:37:04 GMT

Hello Wanki,

try to put in your dimension a differente field name and test your macro, if your sub is correct the problem is the correct syntax in "=if(EQ_ID='" & equips(flg) & "',EQ_ID)".

I suggest you to verify the text for dimension and user for this a variable where you compone your dimension and a message box msgbox v_dimension to see output.

User the function CHR( number ASCII Character ) to concatenate char " and '

I hope this help you.

Regards

Luca Jonathan Panetta

Re: addDimension in Macro

marcus_sommer — Thu, 11 Dec 2014 16:38:48 GMT

Generally it is possible to create calculated dimensions per macro. In your case the syntax with the quotes looks not correct. Use outside from your expression double-quotes an inside single-quotes. The expression should look if you would write inside the chart and then wrapped it in double-quotes.

- Marcus

Re: addDimension in Macro

Fri, 12 Dec 2014 01:16:06 GMT

Hi Luca Jonathan Panetta,

Thank you for your reply.

I tested to see v_dimension ( v_dimension = vTest = "=if(EQ_ID='" & "TEST" & "',EQ_ID)"), it works fine.

But if I change the string like v_dimension = vTest = "=if(EQ_ID='" & equips(flg) & "',EQ_ID)", it doesn't work.

Maybe the variable can not accept to call a function in the string.

Thanks in advance,

WanKi,

Re: addDimension in Macro

Fri, 12 Dec 2014 01:21:43 GMT

Hi Marcus,

I tried to test that you mentioned.

If I put the function call in the string, it doesn't work.

v_dimension = vTest = "=if(EQ_ID='" & equips(flg) & "',EQ_ID)

Is it impossible to call a function in string to assign to variable ?

Thank you so much,

WanKi,

Re: addDimension in Macro

Fri, 12 Dec 2014 01:50:16 GMT

Sorry about my mail.

The equips(flg) is not a function but a array.

So, it works fine.

Very sorry.

WanKi,

Re: addDimension in Macro

Fri, 12 Dec 2014 01:50:37 GMT

Sorry about my mail.

The equips(flg) is not a function but a array.

So, it works fine.

Very sorry.

WanKi,

Re: addDimension in Macro

pljsoftware — Fri, 12 Dec 2014 08:51:38 GMT

Ok Wanky, but what is the solution?

Have you solved your problem?

Regards

Luca Jonathan Panetta

Re: addDimension in Macro

Fri, 12 Dec 2014 10:04:26 GMT

LUca Jonathan Panetta,

I didn't solve yet.

I am looking for a solution.

But I donn't know the answer.

Thank you so much for your help.

Regards,

WAnKi,

Re: addDimension in Macro

marcus_sommer — Fri, 12 Dec 2014 10:24:46 GMT

You could include other variables or functions in this variable but the result should return:

"=YourExpression()"

This meant it's not enough that it is a string it needed the outside double-qoutes as string-part. Therefore you need something like this:

dimen = """"=if(EQ_ID='" & equips(flg) & "',EQ_ID)""""

to create additionally quotes. Further with '" & equips(flg) & "' you would check the field EQ_ID against a string, correct?

- Marcus

Re: addDimension in Macro

pljsoftware — Fri, 12 Dec 2014 10:51:05 GMT

Can you post an example where I try to test your code?

Thanks

Luca Jonathan Panetta

Re: addDimension in Macro

Fri, 12 Dec 2014 12:03:57 GMT

I asked for a sample to my customer.

If I get the one , yes I will post it.

Thank you,

WanKi,

Re: addDimension in Macro

Fri, 12 Dec 2014 12:17:19 GMT

Marcus,

I tried to do that, but didn't work.

The equips() is the variable that is declared as an array.

So I printed the value of 'dimen' ( dimen = "=if(EQ_ID='" & equips(flg) & "',EQ_ID)").

The result is the following. Maybe it's ok.

But the statement, objs(i).AddDimension(dimen), it doesn't work.

Regards,

WanKi,

Re: addDimension in Macro

marcus_sommer — Fri, 12 Dec 2014 12:26:33 GMT

You need it wrapped in double-quotes otherwise it would all content after the first single-quote interpret as comment.

- Marcus

Re: addDimension in Macro

pljsoftware — Fri, 12 Dec 2014 12:37:12 GMT

Hello Wanki,

yes is possible to use a variable to set you dimension.

Look this post http://community.qlik.com/message/30950#30950

The correct SUB is takeII()

Best regards

Luca Jonathan Panetta

Re: addDimension in Macro

Fri, 12 Dec 2014 13:47:39 GMT

Luca Jonathan Panetta !!

WoW !! ^^

Thank you very much for your help.

WanKi,