3 stack bar with value low to high

[manoranjan_d]

hi all, below is the data,

now i need the data in 3 stack bar in single chart.

First  stack bar should tell the sum of IT and CSE

second stack bar should tell the Sum of IT present and Absent

third stack bar should tell the the sum of cse present and absent

note: all these values in the stack bar stock display inside the segment and  the values should sort low to high.

Dept	Count	PorA
IT	500	A
CSE	700	A
IT	800	A
CSE	900	A
IT	1000	A
CSE	1100	A
IT	1200	A
CSE	1300	A
IT	1400	P
CSE	1500	A
IT	1600	P
CSE	1700	P
IT	1800	P
CSE	1900	P
IT	2000	P
CSE	2100	P
IT	2200	P
CSE	2300	P

[MK_QSL]

Are you getting your expected results?

[manoranjan_d]

yes i m getting the accurate output, but i new to the qlikview so cant understand the expression

and also the valuelist() fun. can u say me clearly

[MK_QSL]

Read this blog. If you still not able to understand.. will explain.

Kindly close the thread by selecting correct answer.

ValueList() – For those tricky situations

Missing Manual - ValueLoop() & ValueList()

[manoranjan_d]

thanks