topic Re: Stack color change with set analysis in QlikView

Stack color change with set analysis

Thu, 10 Mar 2016 07:50:16 GMT

Hi Community,

There is a dashboard related to Actual and Plan figures for different Year and Month. I would like the Stack bars of plan figures to show in transparent color. I can do this when I am not selecting any Months. However, due to the set analysis in the expression, the graph can not show my desired result when I choose any one of the month from the list box. When I choose any one of the month, only the month I choose would change to transparent, and other will remain the same color as the Actual stack bars. Please download the provided qvw and have a look of my problem. Thanks a lot.

Re: Stack color change with set analysis

Gysbert_Wassenaar — Thu, 10 Mar 2016 10:06:35 GMT

Try these color expressions:

=if((only({$<BU = {'A'},Scenario={'$(v1)','Actual'},Month=>}Scenario)=v1

and only({$<BU = {'A'},Scenario={'$(v1)','Actual'},Month=>}Year)=2015)

or (only({$<BU = {'A'},Scenario={'$(v1)','Actual'},Month=>}Scenario)=v1

and only({$<BU = {'A'},Scenario={'$(v1)','Actual'},Month=>}Year)=2016), rgb(185,191,238), rgb(122,135,222))

=if(only({$<BU = {'A'},Scenario={'$(v1)','Actual'},Month=>Scenario)=v1,rgb(253,167,157), rgb(252,115,98))

Do these give the result you're after?

Re: Stack color change with set analysis

nagireddy_qv — Thu, 10 Mar 2016 10:10:12 GMT

may be this help you....

go to colors tab.. click on color ... select the two colors Gradient option in the color area...

Re: Stack color change with set analysis

Fri, 11 Mar 2016 02:06:35 GMT

Hi Gysbert,

I have tried both expression. The expression for A works, but the expression for B doesn't.

Can you briefly explain the rationale behind?

Maverick

Re: Stack color change with set analysis

Fri, 11 Mar 2016 02:08:58 GMT

Thanks a lot nagireddy, but it is not my desired result. I would like the user to spot the difference of Actual and Plan figures by transparent color / different colors.

Re: Stack color change with set analysis

Gysbert_Wassenaar — Fri, 11 Mar 2016 13:16:53 GMT

Try =if(only({$<BU = {'A'},Scenario={'$(v1)','Actual'},Month=>}Scenario)=v1,rgb(253,167,157), rgb(252,115,98))

The rationale is that your chart expressions use set analysis to overrule user selections. Your color expressions did not. By changing those to set analysis expressions as well they too will ignore those user selections.

Re: Stack color change with set analysis

Mon, 14 Mar 2016 02:10:24 GMT

Thank you Gysbert!