Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
The above expression should work as expected. Have you tried? Isn't that working?
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
];
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.
Thanks, I am getting values with 'Data, Content *'.