topic Re: Alternate colors in Pivot table in QlikView

Alternate colors in Pivot table

Tue, 02 Dec 2014 08:44:44 GMT

Hi All,

We are having a requirement to show alternate colors in Pivot Table based on Submission ID.

If Submission ID "2" is given blue then next Submission ID "3" should "yellow" then again for 5 it should be blue and for 7 it should be yellow.

I have attached a sample QVW with this. Please let me know if you need any more information.

Thanks,

Sijo

Re: Alternate colors in Pivot table

mato32188 — Tue, 02 Dec 2014 08:56:10 GMT

Hi Sijo,

how is you color calculated? ...if Submission ID "2" is blue... Submission ID "2" is blue, because ...

Re: Alternate colors in Pivot table

morganaaron — Tue, 02 Dec 2014 08:56:24 GMT

Stick this into the "Background Color" definitions for just the expression or expression + dimension if needed:

if(Match([Submission ID],'2','5'), LightBlue(100), Yellow())

You can change the alpha value of the blue, or enter RGB codes if that's more what you want. If you go any darker with the blue I'd also recommend changing the text colour using the same expression to White().

Re: Alternate colors in Pivot table

rajeshvaswani77 — Tue, 02 Dec 2014 09:04:18 GMT

Try this in your background expression.

IF(Even(RowNo(TOTAL)),Yellow(),Blue())

thanks,

Rajesh Vaswani

Re: Alternate colors in Pivot table

emkabi646 — Tue, 02 Dec 2014 09:31:12 GMT

Hi Sijo,

see the background-Color definition in the sample-file.

The Match-function from Aaron is the more elegant solution.

Regards

Martin

Re: Alternate colors in Pivot table

Tue, 02 Dec 2014 10:05:28 GMT

The value's we put 2,5,7 just dummy values. It can be any values from 1..10000.

We need to color when the submission changes from the previous one.

Thanks,

Sijo

Re: Alternate colors in Pivot table

mato32188 — Tue, 02 Dec 2014 10:11:56 GMT

Fine, but very first color in your order is based on some calculation? Like if amount for Submission ID2 is under 300, get blue?

Re: Alternate colors in Pivot table

rajeshvaswani77 — Tue, 02 Dec 2014 11:10:57 GMT

So its alternate colouring right?

Re: Alternate colors in Pivot table

Tue, 02 Dec 2014 11:27:06 GMT

Hi,

If its about the assigning the colour on the basis of Odd and Even Submission IDs then;

Expression->Background Colour -> if(Even(SubmissionID),Blue(),Yellow())

Hope it helps !

Cheers !

Re: Alternate colors in Pivot table

Tue, 02 Dec 2014 11:55:06 GMT

yes

Re: Alternate colors in Pivot table

rajeshvaswani77 — Tue, 02 Dec 2014 11:57:09 GMT

What Priyanka has said holds good then.

Expression->Background Colour -> if(Even(SubmissionID),Blue(),Yellow())

Re: Alternate colors in Pivot table

Tue, 02 Dec 2014 14:46:30 GMT

Thanks Pryanka,

In my scenario, the two even submission can come together according to the user selection. Hence need this to be done when the prevous Submission ID changes. (i.e alternative colors)

Thanks,

Sijo

Re: Alternate colors in Pivot table

Tue, 02 Dec 2014 16:18:17 GMT

Welcome Sijo!

Do mark the answer as Correct to complete this thread !

Cheers !