topic Re: Passing comma separated string into Set analysis in QlikView

Passing comma separated string into Set analysis

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Passing comma separated string into Set analysis

tresB — Thu, 19 Jul 2018 05:38:50 GMT

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

Re: Passing comma separated string into Set analysis

qlikviewwizard — Thu, 19 Jul 2018 05:42:08 GMT

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

];

Re: Passing comma separated string into Set analysis

nihhalmca — Thu, 19 Jul 2018 11:40:47 GMT

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.

Re: Passing comma separated string into Set analysis

nihhalmca — Thu, 19 Jul 2018 12:12:33 GMT

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