topic Re: RE:pie chart colors in QlikView

RE:pie chart colors

Chanty4u — Tue, 09 Jun 2015 04:10:10 GMT

hi guys

need help.

i have one pie chart

nd dimension as year,car brnds,colour red and balk

if i select any one of the sales it wil dispaly both in red nd blk clr so

thank u

Suresh

Re: RE:pie chart colors

tresB — Tue, 09 Jun 2015 04:33:50 GMT

Replace Brandings with Colours in dimension.

Re: RE:pie chart colors

hariprasadqv — Tue, 09 Jun 2015 04:42:10 GMT

Hi,

In my view evrything is fine here, Just enable values on data points option in Expression tab so that you can find the right values.

You are using dimiension limits so what ever the color may be but the brands are fixed to the larget sold brand in the chart.

Use Persistent colors option under color tab for standardizing your app.

Thanks

Re: RE:pie chart colors

hariprasadqv — Tue, 09 Jun 2015 04:43:36 GMT

If you wish to display color wise sales use the respective dimension.

Re: RE:pie chart colors

jagan — Tue, 09 Jun 2015 06:03:31 GMT

Hi,

If you want color wise sales then use Color as dimension in the chart.

Hope this helps you.

Regards,

Jagan.

Re: RE:pie chart colors

Chanty4u — Tue, 09 Jun 2015 06:43:18 GMT

thankyou all,

below are the dim nd sample data..

my req is to disply in one pie chrt use trellis and disalpy one row vil dispaly always BMW and in dat pie chart display only two colors block and red

and last 3yrs sales

Branding color year sales

Scala	Red	2000	700
Duster	Red	2000	750
Kia	Red	2000	800
Bugatti	Red	2000	850
Alpine	Red	2000	900
Citroen	Red	2000	950
Daewoo	Red	2000	1000
Benz	Red	2000	1050
Porsche	Red	2000	1100
Chevrolet	Red	2000	1150
Dodge	Red	2000	1200
GMC	Red	2000	1250
Buick	Red	2000	1300
Audi	Black	2000	1350
BMW	Black	2000	1400
Ford	Black	2000	1450
Wolkwagon	Black	2000	1500
Puegeot	Black	2000	1550
Renault	Black	2000	1600
Mahendra	Black	2000	1650

thank you

Re: RE:pie chart colors

tresB — Tue, 09 Jun 2015 06:48:56 GMT

Like in attached qvw?

Re: RE:pie chart colors

Chanty4u — Tue, 09 Jun 2015 06:51:09 GMT

yes tresesco..

Re: RE:pie chart colors

Chanty4u — Tue, 09 Jun 2015 06:56:38 GMT

hi tresico please find image in dat image i want to dispaly colour where in blk

and red clr where red is in.and last 3yrs data

and only one perticular sales wil remains constnt in chat..

thank you

Re: RE:pie chart colors

tresB — Tue, 09 Jun 2015 07:05:07 GMT

PFA

Re: RE:pie chart colors

Chanty4u — Tue, 09 Jun 2015 07:11:47 GMT

to display last 3yrs data?

Re: RE:pie chart colors

tresB — Tue, 09 Jun 2015 07:16:29 GMT

Check expression:

Sum({<Year={">$(=Max(Year)-3) <=$(=Max(Year))"}>}Sales)

Re: RE:pie chart colors

Chanty4u — Tue, 09 Jun 2015 07:35:57 GMT

tanq its wrkng fyn.

but to dispaly only one brand sales by year in one chart and dat to be constant at d same time wil show below all remaing brdng cars sales by year...?

thank you

suresh