Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Data level logical help

hi ,

      I have attached the sample data and the required output where i can show as per the required output attached in the file at script level need how can i achieve this please help . Want to show category split in bar chart where if their is a combination of 2 category i want to show it as separate count .

1 Reply
Highlighted
Creator II
Creator II

I think this would works.

TI:

load * inline [

MEMBER, CATEGORY, OUTPUT

1, A, A

2, A, A/B

2, B ,A/B

3, C, C

4, A, A

5, B, B

6, C, C/A

6, A, C/A ];

LEFT JOIN

lOAD MEMBER, Concat(CATEGORY,'/') AS NEWOUTPUT RESIDENT TI GROUP BY MEMBER;