Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rohan_chavan15
New 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
scotly-victor
Contributor

Re: Data level logical help

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;

Community Browser