Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can I ALWAYS have a colored dimension (i.e. Green) (even if I haven't filter) ?
thanks!!!!!
Hi,
You could try to add an else, like
=IF ([name dimension]=1,GREEN(),RED())
See attchment
Fred
It should work fine without condition as well. Could you share a sample that shows the issue?
Hi Genni,
It should without if condition as well.
Try
= RGB(0,255,0)
Thanks!
Hi,
Do you have that dimension declared in Dimension tab? If not try using
=IF (Max([name dimension])=1,GREEN())
If not working attach sample file.
Regards,
Jagan.
you can simply put in the background color only the expression =Green() or use RGB() colors, without any if conditions.
I tried ... nothing to do
as soon as I can, I send an example thanks
Hi,
You could try to add an else, like
=IF ([name dimension]=1,GREEN(),RED())
See attchment
Fred
perfect !!!! With the "else" is ok!!!!!
THANKS!!!!
However, for multiple conditions which is the syntax in qlik?
If I have many "IF conditions" (and then many colours)?
Hi Genni,
You can use nested IF:
=IF ([name dimension]=1,GREEN(),
IF([name dimension]=2,YELLOW(),
RED()
)
)