Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rohan_chavan15
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
scotly-victor
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;