Discussion Board for collaboration on QlikView Layout & Visualizations.
Greetimg for the day,
can any one send me expression attributes in a chart expression.
Edit color with:
=if(condition=1, RGB(255,0,0), RGB(0,255,0))
Edit line type with:
decide if show values with:
Hope it helps.
can you try to be a bit more precise? What exactly do you want to do?
The expression attributes are on the "formulas" tab, when you click on the little + to expand.
There is something about them in the help_file, though it's not too much.
i need to give colors to my pivot tables cells diffrent colors for each row based on dimension
can you help me on this .
I don't do much work with pivot_tables - but I guess it works like it does in any other type of chart:
You have to expand as I said, click into the edit_field for "background_colour" and enter an IF_formula there, depending on your dimension - so it would be sth like
>> = IF([dimension] = 'X', BLUE(), RED()) <<