Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro problem again

I have statemaent there I try to give  part of an expressen in macro that i can use in chart.

ActiveDocument.CreateVariable "vExpression"

exp=
"(" &
for i=1 to v
"(out>=vin" &(i)& " and in<=vout" &(i)& " and depatment=vdep" &(i)& ")"&
if(i<v," or ")&
next
")"

'ActiveDocument.Variables("vExpression").SETCONTENT exp,TRUE

What I want to acheve is the variable with the following expression: (out=vin1 and in<=vout1 and depatment=vdep1)  or  (out=vin2 and in<=vout2 and depatment=vdep2) and so on baut there is tomething wrong in my script.

Labels (1)
0 Replies