Issue on the Bar chart

manoranjan_d — Thu, 29 Oct 2015 17:53:12 GMT

Hi all,

below is my data

Data:

item	Dept	PORA	Type
100	IT	P	Computer
200	CSE	P	Computer
300	IT	P	Computer
400	CSE	A	Computer
500	IT	P	Computer
600	CSE	A	Computer
700	IT	A	Computer
800	CSE	P	Computer
900	IT	P	Computer
1000	CSE	A	Computer
1100	IT	P	Computer
1200	CSE	P	Computer
1300	IT	P	Computer
1400	CSE	P	Computer
1500	IT	A	Computer
1600	CSE	P	Computer
1700	IT	A	Computer
1800	CSE	A	Computer

now my dash board have list boxes and charts

list box has value of computer , if user select the computer sub list box of DEPT will appear which has value of IT and CSE

scenario 1:

when the computer is selected from list box a stack bar chart has to appear which should show the sum(item) for P and A. for this stack chart i used dimension as TYPE and PORA and the expression is sum(count). i got this stack bar successfully

scenario 2:

now i selected the computer and then sub list box of IT i selected , a another chart has to appear which should show the sum(item) P and A for computer and as well as for the dept IT with two different stack bar where the values has to be displayed with inside segmet and the value has to be sorted from low to high.

i used two cal dim in the chart

=ValueList('Type','IT')

=ValueList('P','A')

and expression is

IF(ValueList('Type','IT') = 'Type' and ValueList('P','A') = 'P', SUM({<TYPE = {'P'}>}item),

IF(ValueList('Type','IT') = 'Type' and ValueList('P','A') = 'A',SUM({<TYPE = {'A'}>}item),

IF(ValueList('Type','IT')= 'IT' and ValueList('P','A') = 'P', SUM({<Dept= {'IT'}, FR_Type = {'P'}>}item),

IF(ValueList('Type','IT')= 'IT' and ValueList('P','A') = 'A', SUM({<Dept= {'IT'}, FR_Type = {'A'}>}item))))

in sort tab

selected the expression and placed the above expression to make the sort,

now under this scenario 2 i m facing issue with first stack bar doesn't show the correct value for Computer.

how to get the correct stack bar for the second senario

Re: Issue on the Bar chart

manoranjan_d — Tue, 03 Nov 2015 14:53:38 GMT

no reply

topic Re: Issue on the Bar chart in QlikView

Issue on the Bar chart

Re: Issue on the Bar chart