Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

Set Analysis - using a variable to store the whole set

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!

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

2 Replies
YoussefBelloum
Champion
Champion

Hi,

it is working for me.

which qlikview version you have ?

avinashelite

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