Stack bar

[manoranjan_d]

Hi all,

Count	Type	Country	Data source
200	male	UK	Data3
1800	male	UK	data1
28500	Female	US	data5
28500	Female	US	data5
62500	Female	Pak	data5
62500	Female	Pak	data5
97600	Female	China	data5
97600	Female	China	data5
139500	male	india	data1
181800	Female	india	data5
181900	Female	UK	data5
193500	Female	india	data5
200000	male	india	data2
200000	male	Pak	Data3
320500	Female	UK	data5
500400	male	india	Data3
700000	male	UK	data2
800000	male	Pak	data2

above is my data i want the data be viewed in stack bar

as per the country wise, with data source and  then type, and then in that type the i need th overall count

i used dimension as country, data source and type

i used in expresion as =Dual( data source&'-'& Num(Sum(Count),'#,##0','.',','),Sum(Count))

the value has to plot inside segments and then value has to sort and the  colors has to be arranged.

pls help me on this

[nagarjuna_kotha]

Like this u want ?

PFA.....

[#3]

will something like this help

[manoranjan_d]

no khushboo, we also need the data source we are missing in the stack bar...any other solution for this requirement or its drawback in qlikview tool

[manoranjan_d]

I naga we dont want the legends outside , we need inside the stack bar and the value inside the stock bar has to be sorted , my application stuck with only colors and sorting is not performed for some of the stack bars

all the stack bar should use three color blue, orange, and green and these color has to assigned according to the sort value, example

if the stack bar has two values then it should show blue and orange

if the stack bar show one value then it should show only blue

if the stack bar display three value then it shd dsiplay the three color blue, orange and green

[manoranjan_d]

is ithere any other alternative solution for this, bcoz my application stuck with sorting and colors

[manoranjan_d]

is ithere any other alternative solution for this, bcoz my application stuck with sorting and colors

[manoranjan_d]

Atlease if the sort is happened means i will be happy on this