topic Re: Issue in Include() in QlikView

Issue in Include()

Tue, 07 May 2013 06:01:05 GMT

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.

Re: Issue in Include()

sushil353 — Tue, 07 May 2013 06:08:24 GMT

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

Re: Issue in Include()

Gysbert_Wassenaar — Tue, 07 May 2013 06:09:32 GMT

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))';

Re: Issue in Include()

Tue, 07 May 2013 07:04:19 GMT

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

Regards,

Zain.