topic Re: stack Bar issue in QlikView

stack Bar issue

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: stack Bar issue

florentina_doga — Fri, 19 Aug 2016 12:53:47 GMT

see attach

Re: stack Bar issue

MarcoWedel — Sat, 20 Aug 2016 00:10:15 GMT

Hi,

one front end solution might be:

hope this helps

regards

Marco

Re: stack Bar issue

Sun, 21 Aug 2016 05:12:17 GMT

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