topic Re: variable in QlikView

variable

yadav_anil782 — Mon, 28 Sep 2015 13:00:15 GMT

Dear Community,

i want to create a variable with given value

variable name = vinflow

and value should be =Sum({<ACCOUNT_CODE = {"43301","43302","43303",43304"}>}"PERIOD_CR")

i'm trying this script in variable =if(inflow='Sale of Assets',"=Sum({<ACCOUNT_CODE = {"43301","43302","43303",43304"}>}"PERIOD_CR") but its not correct

so if i select "Sale of Assets" baton then value should be come according this given logic .

plz share the solution so i can correct this variable

Re: variable

pokassov — Mon, 28 Sep 2015 13:10:50 GMT

Hi!

variable1:

Sum({$<ACCOUNT_CODE = {43301,43302,43303,43304}>} PERIOD_CR)

variable2:

if(inflow='Sale of Assets',$(variable1))

Re: variable

avinashelite — Mon, 28 Sep 2015 13:25:42 GMT

Hi Anil,

For your information SET ANALYSIS does not work in script you need to do a separate group by calculation in the script and assign this to variable.

Try the same in front end this should work

Re: variable

Mon, 28 Sep 2015 13:32:48 GMT

what do you mean when you say it is not correct?

Below is what I believe will work based on the variable you currently want to define

variable name = vinflow

and value should be =Sum({<ACCOUNT_CODE = {"43301","43302","43303",43304"}>}PERIOD_CR)

if(inflow='Sale of Assets',$(vinflow))

This follows the other recommendation but is using the variable(s) you have defined

Re: variable

Digvijay_Singh — Mon, 28 Sep 2015 13:37:20 GMT

Your set expression syntax has problem -

=Sum({<ACCOUNT_CODE = {"43301","43302","43303",43304"}>}"PERIOD_CR") should be like -

=Sum({<ACCOUNT_CODE = {"43301","43302","43303","43304"}>}PERIOD_CR)

Avoid double quote if Code is numeric.

Re: variable

yadav_anil782 — Tue, 29 Sep 2015 08:43:23 GMT

Dear Avinas,

surely we can't use script in variable , i was talking about variable value which in need to use for shared button "Sale of Assets"

Re: variable

yadav_anil782 — Tue, 29 Sep 2015 09:06:23 GMT

i'm using this variable for value calculation and this variable working fine

=if(Value='Crores',10000000,if(Value='Thousand',1000,if(Value='Lakhs',100000,if(Value='Millions',100000))))

same this type of variable i want to use for my one analysis which i shared prviusly and still i'm stuck on that

=if(inflow='Sale of Assets',=Sum({<ACCOUNT_CODE = {4332"}>}"PERIOD_CR"),

=if(inflow='Intrast received on fd and bank account',=Sum({<ACCOUNT_CODE ={"43301","43302","43303",43304"}>}"PERIOD_CR"),=if(inflow='Return from mutul fund',"=Sum({<ACCOUNT_CODE = {"43302","43303",43304"}>}"PERIOD_CR"),=if(inflow='Loan&Borrowing',=Sum({<ACCOUNT_CODE = {"43302","43303",43304"}>}"PERIOD_CR")

Re: variable

avinashelite — Tue, 29 Sep 2015 09:21:58 GMT

can you please share the sample app with data and output your excepting ...will workout of the same