Discussion Board for collaboration on QlikView Layout & Visualizations.
Can I ALWAYS have a colored dimension (i.e. Green) (even if I haven't filter) ?
Go to Solution.
You could try to add an else, like
=IF ([name dimension]=1,GREEN(),RED())
It should work fine without condition as well. Could you share a sample that shows the issue?
It should without if condition as well.
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.
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
perfect !!!! With the "else" is ok!!!!!
However, for multiple conditions which is the syntax in qlik?
If I have many "IF conditions" (and then many colours)?
You can use nested IF:
=IF ([name dimension]=1,GREEN(),