topic Re: 3 stack bar with value low to high in QlikView

3 stack bar with value low to high

manoranjan_d — Wed, 21 Oct 2015 15:24:35 GMT

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

Re: 3 stack bar with value low to high

manoranjan_d — Wed, 21 Oct 2015 15:27:12 GMT

in the stack bar i need the IT and CSE has to segregated

Re: 3 stack bar with value low to high

manoranjan_d — Wed, 21 Oct 2015 18:26:17 GMT

no reply

Re: 3 stack bar with value low to high

MK_QSL — Wed, 21 Oct 2015 19:04:15 GMT

Like this?

Re: 3 stack bar with value low to high

MK_QSL — Wed, 21 Oct 2015 19:06:53 GMT

Or simple create a Bar Chart

Dimension : No Dimension

Expressions

1) SUM(Count)

2) SUM({<Dept = {'IT'}, PorA = {'P','A'}>}Count)

3) SUM({<Dept = {'CSE'}, PorA = {'P','A'}>}Count)

Go to Style Tab and Select Stacked From SubType

Re: 3 stack bar with value low to high

manoranjan_d — Wed, 21 Oct 2015 19:38:26 GMT

no wrong , i need separate stack bar

Re: 3 stack bar with value low to high

MK_QSL — Thu, 22 Oct 2015 06:20:43 GMT

Create a Bar Chart

Use two Calculated Dimensions

1) =ValueList('All','IT','CSE')

2) =ValueList('A','P')

Use below Expression

IF(ValueList('All','IT','CSE') = 'All' and ValueList('A','P') = 'A', SUM({<PorA = {'A'}>}Count),

IF(ValueList('All','IT','CSE') = 'All' and ValueList('A','P') = 'P', SUM({<PorA = {'P'}>}Count),

IF(ValueList('All','IT','CSE') = 'IT' and ValueList('A','P') = 'A', SUM({<PorA = {'A'}, Dept = {'IT'}>}Count),

IF(ValueList('All','IT','CSE') = 'IT' and ValueList('A','P') = 'P', SUM({<PorA = {'P'}, Dept = {'IT'}>}Count),

IF(ValueList('All','IT','CSE') = 'CSE' and ValueList('A','P') = 'A', SUM({<PorA = {'A'}, Dept = {'CSE'}>}Count),

IF(ValueList('All','IT','CSE') = 'CSE' and ValueList('A','P') = 'P', SUM({<PorA = {'P'}, Dept = {'CSE'}>}Count)))))))

Re: 3 stack bar with value low to high

manoranjan_d — Mon, 26 Oct 2015 22:07:57 GMT

is this only one expression

Re: 3 stack bar with value low to high

MK_QSL — Tue, 27 Oct 2015 07:30:26 GMT

Yes

Re: 3 stack bar with value low to high

manoranjan_d — Wed, 28 Oct 2015 07:22:44 GMT

thanks manish, but can u expalin the expression

Re: 3 stack bar with value low to high

MK_QSL — Wed, 28 Oct 2015 07:54:41 GMT

Are you getting your expected results?

Re: 3 stack bar with value low to high

manoranjan_d — Wed, 28 Oct 2015 13:11:50 GMT

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

Re: 3 stack bar with value low to high

MK_QSL — Wed, 28 Oct 2015 15:49:35 GMT

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()

Re: 3 stack bar with value low to high

manoranjan_d — Wed, 28 Oct 2015 15:50:58 GMT

thanks