Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
You are there! Please see the screen shot.
You can write expression for condition here, right?
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
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.
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
Hello!
Try it:
If(Sum(SpalteB) >= 2,RGB(252,115,98), RGB(255,255,255))
worked?
try this:
=IF(Right(GetActiveSheetId(), 4) = 'SH03', RGB(252,115,98))
Just change the number 'SH0xx' for each tab.
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