How to count member and summary sale amount when I want to present

[panwipa2528]

I have raw data sale by branch as below

Member ID	Sale Amount	Bill No.	Day	Branch
1001	500	1	1	A
1002	1000	2	1	A
1001	1050	3	2	B
1002	500	4	2	A
1002	500	5	3	C
1003	100	6	3	B
1003	500	7	3	C
1002	700	8	4	B

i want to present as below  Table

Branch	B		C
	Member	Sum Sale Amount	Member	Sum Sale Amount
A	2 count distinct only member who but branch A&B	3,250 Sum Sale Amount who but branch A&B	1 count distinct only member who but branch A&C	1,000 Sum Sale Amount who but branch A&C
B			1 count distinct only member who but branch B&C	1,500 Sum Sale Amount who but branch A&C

[dsharmaqv]

Count({$<Branch={'A','B'}>} DISTINCT Member)

In the same way you can perform oyher calculations as well

For more details on set analysis you can refer below link

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-a...

hope it helps

[migueldelval]

Hi Panwipa,

Please check this attached file.

Regards

Miguel dle Valle