Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nihhalmca
Valued Contributor 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
Honored Contributor II

Re: Passing comma separated string into Set analysis

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
MVP
MVP

Re: Passing comma separated string into Set analysis

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

qlikviewwizard
Honored Contributor II

Re: Passing comma separated string into Set analysis

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

nihhalmca
Valued Contributor II

Re: Passing comma separated string into Set analysis

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.

Highlighted
nihhalmca
Valued Contributor II

Re: Passing comma separated string into Set analysis

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