topic Re: Stack bar in QlikView

Stack bar

manoranjan_d — Thu, 12 Nov 2015 19:57:12 GMT

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

Re: Stack bar

manoranjan_d — Thu, 12 Nov 2015 21:10:13 GMT

pls any one reply me

Re: Stack bar

manoranjan_d — Thu, 12 Nov 2015 21:53:07 GMT

Re: Stack bar

manoranjan_d — Thu, 12 Nov 2015 22:03:49 GMT

i m totally stuck with this pls help me

Re: Stack bar

Fri, 13 Nov 2015 08:27:25 GMT

sample application pls

Re: Stack bar

miguelbraga — Fri, 13 Nov 2015 10:47:25 GMT

Hey there,

As khushboo Pewani asked, I ask again. Can please share your qvw? I'll try to understand your issue and make your solution come true

Thanks,

Re: Stack bar

Anonymous — Fri, 13 Nov 2015 11:04:11 GMT

will it fit?

PFA..

Re: Stack bar

Anonymous — Fri, 13 Nov 2015 11:18:16 GMT

If you want to stack chart like this: to get the style of stack chart minimum teo expression required

See the attachment....u can change it as per ur requirement

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:19:41 GMT

Hi,

I ave attached the values not sorted and colors are not proper order

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:22:44 GMT

Hi all,

i have attached the file for your reference, i need the colors to be in proper order and then the values has to be sorted from low to high

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:26:35 GMT

I've attached the file pls refer

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:28:13 GMT

I've attached the file for your refernce

Re: Stack bar

Anonymous — Fri, 13 Nov 2015 11:28:40 GMT

is this you want?

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:38:33 GMT

no, when u see the value of second stack bar values are not in low to high ,

when u see the fourth stack bar the color is getting differ becoz, we shd get only sky blue and orange in proper order.we are getting orange and green in the fourth stack bar.

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:48:17 GMT

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

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 11:49:34 GMT

these inside value has to be sorted from low to high

Re: Stack bar

Fri, 13 Nov 2015 12:16:13 GMT

See attached for sort

Re: Stack bar

Anonymous — Fri, 13 Nov 2015 12:26:57 GMT

It works for 2 dimension but when we add DataSource as well it doesnt work

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 12:43:31 GMT

where is the data source kushshboo

Re: Stack bar

manoranjan_d — Fri, 13 Nov 2015 12:44:22 GMT

this is the thing i m totally stuck no sol for this , please help me with some other solution i can propose it