stack Bar issue

[#1]

Dear All,

I have below source and wanted to create a stacked Bar chart on below 3 Status values. I have given my required result also.  I have made it in database level using sub queries, but couldn't get in Qlikview. 

Thanks,

Source
C_id	P_id	V_id	Privacy_status
C1	p1	v1	public
C1	p1	v2	public
C1	p1	v3	public
C1	p2	v45	public
C1	p2	v33	private
C1	p2	v32	private
C1	p3	v1	private
C1	p3	v11	private
C1	p4	v77	public
C1	p5	v22	public
C1	p5	v98	private

Result:

Result
C_id	status	count(distinct P_id)
C1	public	2
C1	private	1
C1	mix	2

[florentina_doga]

see attach

[MarcoWedel · Accepted solution]

Hi,

one front end solution might be:

hope this helps

regards

Marco

[#4]

Thank you so much Marco. its solved my problem!!!