topic Re: How to display two colors in barchart in QlikView

How to display two colors in barchart

kulasekhar — Sat, 08 Aug 2015 18:57:36 GMT

Hi All,

I want display batem 25% in Purple color remaining Blue color.

please send me sample qvw.

Thanks

sekhar.

Re: How to display two colors in barchart

sunny_talwar — Sat, 08 Aug 2015 19:01:30 GMT

Not sure I understand your requirement. Would you be able to share few lines of sample data and explain your expected result?

Re: How to display two colors in barchart

kulasekhar — Sat, 08 Aug 2015 19:40:39 GMT

like that Sunny

Re: How to display two colors in barchart

Anonymous — Sat, 08 Aug 2015 19:43:52 GMT

It is called stacked subtype of the bar chart with two expressions. One expression has one color, the second expression has a different color. Upload your app if you need a more specific answer.

Re: How to display two colors in barchart

robert_mika — Sat, 08 Aug 2015 21:29:35 GMT

Maybe I'm wrong but what kula is asking for is that 25% of one field is purple and the rest blue..

Re: How to display two colors in barchart

MarcoWedel — Sat, 08 Aug 2015 22:09:46 GMT

Hi,

one solution could be:

hope this helps

regards

Marco

Re: How to display two colors in barchart

Anonymous — Sat, 08 Aug 2015 22:12:54 GMT

I depends what to read - the opening post or the follow-up picture

Anyway, if create two expressions, one is 25% of the whole expression another is 75% and use stacked option, it wil work.

Attached an example

Re: How to display two colors in barchart

robert_mika — Sat, 08 Aug 2015 23:32:25 GMT

Hi Michael,

I'm on PE could you attached screen shoot,please?

Re: How to display two colors in barchart

Anonymous — Sun, 09 Aug 2015 02:08:17 GMT

Sure Robert:

Re: How to display two colors in barchart

robert_mika — Sun, 09 Aug 2015 02:20:24 GMT

Thank you Michael but I thought that the problem here is to have the color split across all the bars.

The purple is 25% the blue is 75%

Re: How to display two colors in barchart

kulasekhar — Sun, 09 Aug 2015 06:06:35 GMT

Hi Michael,

The first 25% Purple color the remaining Blue color

Like that Michael.

Thanks

SEKHAR.

Re: How to display two colors in barchart

kulasekhar — Sun, 09 Aug 2015 08:35:06 GMT

Hi Robert,

The first 25% Purple color the remaining Blue color

Like that Robert.

Thanks

SEKHAR.

Re: How to display two colors in barchart

sunny_talwar — Sun, 09 Aug 2015 08:52:06 GMT

Something like this?

Script:

Table:

LOAD * Inline [

Dim, Value

A, 5

B, 13

C, 20

D, 10

E, 2

];

Join(Table)

LOAD Sum(Value) as TotalValue

Resident Table;

FinalTable:

LOAD Dim,

Value,

TotalValue,

Value/TotalValue as PercentValue

Resident Table;

FinalTable1:

LOAD *,

TotalPercentValue - 0.25 as TotalPercentValue1;

LOAD *,

PercentValue + Alt(Peek('TotalPercentValue'), 0) as TotalPercentValue

Resident FinalTable

Order By Dim;

DROP Table Table, FinalTable;

All Fields of FinalTable1 in a table box object:

Bar Chart Dimension: Dim

Bar Chart Expressions:

1) =If(TotalPercentValue1 < 0, PercentValue, If(TotalPercentValue1 = Min({<TotalPercentValue1 = {'>0'}>} TOTAL TotalPercentValue1), PercentValue - TotalPercentValue1))

2) =If(TotalPercentValue1 = Min({<TotalPercentValue1 = {'>0'}>} TOTAL TotalPercentValue1), TotalPercentValue1, If(TotalPercentValue1 > 0, PercentValue))

Attaching the QVW for reference.

HTH

Best,

Sunny

Re: How to display two colors in barchart

Sun, 09 Aug 2015 13:18:09 GMT

Hi.

Can you send the sample database (excel or something). I couldn't get 25% of what

(plz send if this question is still not solved)

Re: How to display two colors in barchart

Anonymous — Sun, 09 Aug 2015 13:45:51 GMT

Hi Michael,

I guess kula sekhar is expecting X- axis first 25% is Purple colour and rest 75% in Blue colour.

Re: How to display two colors in barchart

Anonymous — Sun, 09 Aug 2015 14:08:51 GMT

Am i correct Kula Sekhar???

Re: How to display two colors in barchart

Digvijay_Singh — Sun, 09 Aug 2015 19:06:15 GMT

The bars are depicting some values, right? So the requirement is to show first 25% of total value( may be shown under first 1,2,2.5..bars) in purple color and rest of the total values( depicted under rest of the bars..) in blue color.

Re: How to display two colors in barchart

Digvijay_Singh — Sun, 09 Aug 2015 20:55:23 GMT

Great! This is working perfectly! I think change in bcgrnd color in expression may reflect the purple and blue color, cannot see the qvw as I have PE.

Would you mind explaining one thing, may be silly one, how come a single row'TotalValue' joined to Dim of 'TABLE' without having any matching key. I think I am missing something basic here.

Join(Table)

LOAD Sum(Value) as TotalValue

Resident Table;

Thanks again, your posts r helping a lot. Take care,

Re: How to display two colors in barchart

sunny_talwar — Mon, 10 Aug 2015 03:05:04 GMT

Hey Digvijay I am glad you are getting to learn from me . And trust me no questions are silly. To answer your question, when there are no matching keys between the table you are joining from and the table you join to then you end up forming a Cartesian product. But for this particular case where TotalValue is just a single value it is added as a new column with one value for each of the rows.

Example:

Before Join

Dim, Value

A, 10

B, 20

C, 30

TotalValue

AfterJoin

Dim, Value, TotalValue

A, 10, 60

B, 20, 60

C, 30, 60

I hope the above example will clarify things.

Best,

Sunny

Re: How to display two colors in barchart

Anonymous — Mon, 10 Aug 2015 04:18:55 GMT

I'm maybe a little late...

See attached solution which is purely front-end, nothing in the script to support it. The advantage is that it is dynamic, and the 25% is defined in a variable, so it can be changed easily to any other %.

Still it doesn't work properly in some conditions, e.g. if the first value is greater than the 25%. I'll maybe get back to clean it up, or maybe somebody else will do it before...