Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in Include()

Hi,

I am using $(Include=abc.txt); in script and its working fine but its didnt show $(vThisYear) in variable for example

i define

set vKPI.MinimumOpeningSale.OpeningSale.zain=(Sum({$ <[Fact Type]={"Transaction"}, Revenue_Flag_Value={"1","-1"}, Year={$(vThisYear)} >} Price));

in abc.txt file.

but after reload its show me the variable vKPI.MinimumOpeningSale.OpeningSale.zain value is given below

(Sum({$ <[Fact Type]={"Transaction"}, Revenue_Flag_Value={"1","-1"}, Year={ } >} Price));

in qlikview, kindly guide me.

Regards,

Zain.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can break up the string in more parts:

LET vKPI.MinimumOpeningSale.OpeningSale.zain= '(Sum({$ <[Fact Type]={"Transaction"}, Revenue_Flag_Value={"1","-1"}, Year={$' & '(vThisYear)} >} Price))';



talk is cheap, supply exceeds demand

View solution in original post

3 Replies
sushil353
Master II
Master II

Hi,

You need to assign some value to your variable before executing the include statement.

try this:

LET vThisYear=2011;

$(Include=abc.txt);

This will give you:

(Sum({$ <[Fact Type]={"Transaction"}, Revenue_Flag_Value={"1","-1"}, Year={2011 } >} Price));

HTH

Sushil

Gysbert_Wassenaar

You can break up the string in more parts:

LET vKPI.MinimumOpeningSale.OpeningSale.zain= '(Sum({$ <[Fact Type]={"Transaction"}, Revenue_Flag_Value={"1","-1"}, Year={$' & '(vThisYear)} >} Price))';



talk is cheap, supply exceeds demand
Not applicable
Author

Thanks dear its workingin text file, when i define in excel the its not working, kindly see the attachment.

Regards,

Zain.