topic Re: Higlight a tap (Worksheet) accroding to a condition in QlikView

Higlight a tap (Worksheet) accroding to a condition

Wed, 16 Oct 2013 09:39:33 GMT

Hallo,

Maybe someone could help me. In QlikView you have the posibility to set the color of a tap (worksheet)

Menu: Settings -> Worksheet settings -> tap -> other colors

Is it possible to change the color of an tap according to a condition.

Do someone has an idea?

Thanks a lot Thomas

Re: Higlight a tap (Worksheet) accroding to a condition

swuehl — Wed, 16 Oct 2013 09:43:01 GMT

Have you tried just entering a condition (in the expression for calculated base color), like

=if(vTest = 1,lightred(), white())

vTest is a variable here, but you can use any condition.

Re: Higlight a tap (Worksheet) accroding to a condition

tresB — Wed, 16 Oct 2013 09:47:13 GMT

You are there! Please see the screen shot.

You can write expression for condition here, right?

Re: Higlight a tap (Worksheet) accroding to a condition

Wed, 16 Oct 2013 11:47:44 GMT

Hi,

thanks for your answer. It seems really easy but it doesn't works.

Example Application:

In this example two rows are selected in tablechart (diagramm) according to this condition:

If(SpalteA='a',If(SpalteB>= 2,RGB(252,115,98),Null()),

If(SpalteA='c',If(SpalteB= 1,RGB(252,115,98),Null())))

If I use the same condtion for a tap (settings within a worksheet) it doesn't work.

Do you have an idiea

Thanks Thomas

Re: Higlight a tap (Worksheet) accroding to a condition

swuehl — Wed, 16 Oct 2013 11:50:28 GMT

Yes, because there is no unambiguous answer to get the value of SpalteA or SpalteB in the context of the tab, unless you select a value in both fields.

Re: Higlight a tap (Worksheet) accroding to a condition

Wed, 16 Oct 2013 16:16:27 GMT

Hello,

thanks for your answer. Isn't there any possibility. If I select value 2 and value 1 manually within a multibox the tab will change it's colour in red.

Is there any possibility to select a value (to mark values) within a multibox according to a condition.

I would use the same condition as I used in table chart "Beispiel Farben" to get the same amount of values.

Is there any other possibility for such kind of functionality.

Thanks a lot for help

Thomas

Re: Higlight a tap (Worksheet) accroding to a condition

offjunior — Thu, 24 Oct 2013 16:27:18 GMT

Hello!

Try it:

If(Sum(SpalteB) >= 2,RGB(252,115,98), RGB(255,255,255))

Re: Higlight a tap (Worksheet) accroding to a condition

offjunior — Thu, 24 Oct 2013 17:29:35 GMT

worked?

Re: Higlight a tap (Worksheet) accroding to a condition

fabio_vallone — Thu, 24 Oct 2013 17:45:11 GMT

try this:

=IF(Right(GetActiveSheetId(), 4) = 'SH03', RGB(252,115,98))

Just change the number 'SH0xx' for each tab.

Re: Re: Higlight a tap (Worksheet) accroding to a condition

Fri, 25 Oct 2013 08:55:05 GMT

Hi Thomas,

Please refer the attached qvw may be that could help. Right click on Main tab and then in sheet properties under General Tab,select Radio button Custom colors.

Click Calculated in Base Color and give your condition there.

I have set condition for data value 10. Select value 10 in the multibox in the attached qvw and the tab colour will change.

Hope this helps.

Regards,

Varsha

Re: Higlight a tap (Worksheet) accroding to a condition

Fri, 25 Oct 2013 09:04:30 GMT

HI Thomas

There is no way to change the color until the condition is set.

But in your example the color is an attribute of a value in a column.

If there is no selection you can't match the condition.

Best regards

Chris

Re: Higlight a tap (Worksheet) accroding to a condition

Fri, 25 Oct 2013 09:13:07 GMT

Hello,

I think it has to work. it works but only for the first condtions see picture below.

If SpalteA = 'a' and SpalteB = 2. The tap will change it's color. if I change the Value in Table Chart SpaltB into 1 the tap wil lose it's color.

But it's not working for SpaalteA ='b', SpalteA='c'. Do you have an Idea

Re: Higlight a tap (Worksheet) accroding to a condition

fabio_vallone — Fri, 25 Oct 2013 09:56:42 GMT

Missed "Sum" in other conditions (Sum is working just for first expression).

Re: Higlight a tap (Worksheet) accroding to a condition

Fri, 25 Oct 2013 10:01:13 GMT

Hello,

I have the solution.

= if(sum((SpalteA = 'a' and SpalteB = 2) or

(SpalteA = 'b' and SpalteB = 2) or

(SpalteA = 'c' and SpalteB = 2)), RGB(252,115,98), RGB(255,255,255))

The bracket was the problem

thanks Thomas

Re: Re: Higlight a tap (Worksheet) accroding to a condition

offjunior — Fri, 25 Oct 2013 10:18:40 GMT

Good day friend!

Please mark my answer above as correct, because the solution you're saying that I ran passed him above. So others can use this same solution. We will collaborate with the community.

Re: Higlight a tap (Worksheet) accroding to a condition

offjunior 24/Out/2013 12:27 (em resposta a Thomas Walldorf)

Hello!

Try it:

If(Sum(SpalteB) >= 2,RGB(252,115,98), RGB(255,255,255))