topic Re: using variable in expresion in QlikView

using variable in expresion

lukas_sokol — Thu, 29 Oct 2015 11:53:58 GMT

Hi,

I have the following problem

I have variable vUserCompanyCode with store company codes (loaded from excel) for specifed user

I have sample expresion below ( working)

sum( if( WildMatch(CompanyCode, 10,20,25,30) , NetSales))

but when i use variable ( the result is emty), variable have the same value (10,20,25,30)

sum( if( WildMatch(CompanyCode,$(vUserCompanyCode)) , NetSales))

Regards

Łukasz

Re: using variable in expresion

Thu, 29 Oct 2015 18:49:55 GMT

why dont you use set analysis instead to narrow down the Company codes.

sum( {<CompanyCode={$(=vUserCompanyCode)}>} NetSales)

Re: using variable in expresion

lukas_sokol — Thu, 29 Oct 2015 19:59:26 GMT

I also try use set analysis as you write.

Unfortunately, it not helps

Re: using variable in expresion

Thu, 29 Oct 2015 21:07:20 GMT

what is the exacts out put of the variable vUserCompanyCode?

it should work if it is- 10,20,25,30

Sample qvw would help too

Re: using variable in expresion

tamilarasu — Thu, 29 Oct 2015 23:53:29 GMT

Hi Lukasz,

Change the variable vUseCompanyCode values Format like below,

'10', '20', '25', '30'

Expression as

sum( if( WildMatch(CompanyCode,$(vUserCompanyCode)) , NetSales))

Re: using variable in expresion

lukas_sokol — Fri, 30 Oct 2015 08:52:29 GMT

Hi,

I did a test, and if I directly enter values ('10', '20', '25', '30') to vUserCompanyCode variable then all options work( with set analysis, wildmatch,match)

However, In this variable, I use the expression

FieldValue ('available Company' Field Index ('user', FieldValue ('user', fieldIndex ('user', $ (vUser)))))

where vUser is trim(rtrim(subfield(osuser(),'\',2)))

I check then what value store variable and I get '10', '20', '25', '30'.

Maybe text format is wrong?

Re: using variable in expresion

Gabriel — Fri, 30 Oct 2015 09:13:16 GMT

Hi,

Try this

Sum({<CompanyCode={'$(vUserCompanyCode)'}>} NetSales)

Re: using variable in expresion

lukas_sokol — Fri, 30 Oct 2015 09:25:45 GMT

Unfortunately, it did not help.

I noticed one more thing.

If I load to this variable only one company code, then everything works, if I load more than one Unfortunately not.

Re: using variable in expresion

Anonymous — Fri, 30 Oct 2015 09:30:22 GMT

Simply write in your variable as =10,20,25,30

Then write an expression like below;

Sum({<CompanyCode ={$(vUserCompanyCode)}>}Net Sales)

Re: using variable in expresion

Anonymous — Fri, 30 Oct 2015 10:19:08 GMT

Dear Lukasz,

I believe your question has been answered. kindly mark the thread as answered, so that other members can refer to this post.

Re: using variable in expresion

lukas_sokol — Fri, 30 Oct 2015 18:18:13 GMT

vUserCompanyCode is dynamic variable, so I can't assing values directly

if I have more than one Company code in variable thats not working.

Re: using variable in expresion

lukas_sokol — Fri, 30 Oct 2015 18:29:27 GMT

If in the set analysis I add condition

and WildMatch(CompanyCode, 10,20, 30) --this is ok

if i use variable $(vUserCompanyCode)

when variable $(vUserCompanyCode) = 10

and WildMatch(CompanyCode, $(vUserCompanyCode)) --this is ok

when variable $(vUserCompanyCode) = 10,20,30

and WildMatch(CompanyCode, $(vUserCompanyCode)) --this is NOT ok

Re: using variable in expresion

Fri, 30 Oct 2015 22:46:04 GMT

Hi,

This should do the trick:

sum({$< $(='CompanyCode= {' & $(vUserCompanyCode) & '}') >}NetSales)

Best regards,

Daniel

Re: using variable in expresion

tamilarasu — Sat, 31 Oct 2015 05:00:41 GMT

No. The vUserComnayCode variable looks fine. You need to change the expression as sum( {<CompanyCode={$(=vUserCompanyCode)}>} NetSales).. Since you are using formula in your vUserCompanyCode. If the above one not work, then try with '$(vUserCompanyCode)'.. Let me know..

Re: using variable in expresion

tamilarasu — Sat, 31 Oct 2015 05:12:44 GMT

You can also try like

Sum({<CompanyCode={"$(=$(vUserCompanyCode))"}>} NetSales)

Re: using variable in expresion

lukas_sokol — Sat, 31 Oct 2015 11:56:35 GMT

Than's evryone for help

The below expression works fine

sum({<CompanyCode={$(=vUserCompanyCode)}>} FakturabeloppBase)

but one more thing, definition of vUserCompanyCode must start with "="

Regards

Łukasz