Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
palo173
Contributor III
Contributor III

Set analysis with list of variable

Hi,

could you help me with my variable, which I need to use in set analysis

variable:
vDistrict=Concat(DISTINCT chr(39)&Dim_LT&chr(39),',')
My variable has values: palo173_0-1713184742932.png

Expression return 0, but it is wrong result:
Sum({< Fakt = {'Fakt_1'}, Rok = {'$(vRokDND)'}, [District] = {'=ValueList($(vDistrict))'} >}[#Reg])

Thank you

 

Labels (5)
1 Solution

Accepted Solutions
palo173
Contributor III
Contributor III
Author

Thanks, you were partly right, the ValueList is useless, but there was still a problem with quotes that shouldn't have been there. This is how it should be right:

Sum({< Fakt = {'Fakt_1'}, Rok = {'$(vRokDND)'}, [District] = {$(vDistrict)} >}[#Reg])

View solution in original post

3 Replies
mpc
Partner - Specialist
Partner - Specialist

Hi, 

Sum({< Fakt = {'Fakt_1'}, Rok = {"$(=vRokDND)"}, [District] = {"$(=vDistrict)"} >}[#Reg])
Maybe this one ? 

Regards

From Next Decision and me with love
This answer help you ? Like it ! Problem solved ? Mark it !
palo173
Contributor III
Contributor III
Author

Thanks, you were partly right, the ValueList is useless, but there was still a problem with quotes that shouldn't have been there. This is how it should be right:

Sum({< Fakt = {'Fakt_1'}, Rok = {'$(vRokDND)'}, [District] = {$(vDistrict)} >}[#Reg])

mpc
Partner - Specialist
Partner - Specialist

OH you're right my bad ! Glad to know it's working fine. 

From Next Decision and me with love
This answer help you ? Like it ! Problem solved ? Mark it !