topic Re: Set Analysis - using a variable to store the whole set in QlikView

Set Analysis - using a variable to store the whole set

chriys1337 — Tue, 19 Dec 2017 10:23:03 GMT

HI,

I am struggling with a Set Analysis expression, which should work (when I look at the documentation):

I have defined a Variable in the script, to "ignore" two fields.

LET vL.IgnoreDim ='[Customer Code]=,Matchcode=';

When I try to use this Variable in my Set Analysis Expression the error "Errors in expression" pops up.

sum({<$(vL.IgnoreDim) >} Sales)

When I do it this way, without a Variable, of course it works:

sum({<[Customer Code]=,Matchcode= >} Sales)

Any idea? Thanks for your help!

Re: Set Analysis - using a variable to store the whole set

YoussefBelloum — Tue, 19 Dec 2017 10:35:39 GMT

Hi,

it is working for me.

which qlikview version you have ?

Re: Set Analysis - using a variable to store the whole set

avinashelite — Tue, 19 Dec 2017 10:45:08 GMT

i feel its showing with the red underline but the expression is working fine ??

its the know thing...when you use a variable in set analysis with comparing dimension this happens ..it will show has error in expression but the expression will give desired result