Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Higlight a tap (Worksheet) accroding to a condition

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

Settings.bmp

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

Tap.bmp

Do someone has an idea?

Thanks a lot Thomas

14 Replies
swuehl
MVP
MVP

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.

tresesco
MVP
MVP

You are there! Please see the screen shot.

color.png

You can write expression for condition here, right?

Not applicable
Author

Hi,

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

Example Application:

Beispiel.bmp

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

swuehl
MVP
MVP

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.

Not applicable
Author

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

offjunior
Creator
Creator

Hello!

Try it:

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

offjunior
Creator
Creator

worked?

fabio_vallone
Creator
Creator

try this:

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

Just change the number 'SH0xx' for each tab.

Not applicable
Author

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