Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Passing comma separated string into Set analysis

Hi All,

I want to pass comma separated string into Set analysis, for instance:

Sum({<Department = {'Data, Content Services'}>} Value).

Note: Can not change department name and have to find solution at qlik side.

Thanks,

Nihhal.

1 Solution

Accepted Solutions
qlikviewwizard
Master II
Master II

Hi Nihhal L,

we can achieve like this.

Data:

LOAD * INLINE [

No,Department ,Value

1,'Data, Content Services',10

2,'Data, Content Services',20

3,'Data, Content Services',30

4,'Data, Content Services',40

5,Data,50

6,Content,60

7,Services,70

];

1.png

2.png

View solution in original post

4 Replies
tresesco
MVP
MVP

The above expression should work as expected. Have you tried? Isn't that working?

qlikviewwizard
Master II
Master II

Hi Nihhal L,

we can achieve like this.

Data:

LOAD * INLINE [

No,Department ,Value

1,'Data, Content Services',10

2,'Data, Content Services',20

3,'Data, Content Services',30

4,'Data, Content Services',40

5,Data,50

6,Content,60

7,Services,70

];

1.png

2.png

nihhalmca
Specialist II
Specialist II
Author

Hi Tresesco, This is working here but in real scenario i am using number of departments and i am getting numbers for all departments except 'Data, Content Services'. However its working now after applied * as 'Data, *'. Really i am not sure how it works individually.

nihhalmca
Specialist II
Specialist II
Author

Thanks, I am getting values with 'Data, Content *'.