using variable in expresion

[lukas_sokol]

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

[#2]

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

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

[lukas_sokol]

I also try use set analysis as you write.

Unfortunately, it not  helps

[#4]

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

[tamilarasu]

Hi Lukasz,

Change the variable vUseCompanyCode values Format like below,

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

Expression as

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

[lukas_sokol]

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?

[Gabriel]

Hi,

Try this

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

[lukas_sokol]

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.

[Anonymous]

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

Then write an expression like below;

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

[Anonymous]

Dear Lukasz,

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