Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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