Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

can any one send me expression attributes in a chart expression

Hi all,

Greetimg for the day,

can any one send me expression attributes in a chart expression.

Thanks,

Venkat

4 Replies
marcarreras
Valued Contributor

Re: can any one send me expression attributes in a chart expression

Venkat,

Edit color with:

=if(condition=1, RGB(255,0,0), RGB(0,255,0))

Edit line type with:

='<s2>'

decide if show values with:

=if(condition=1, 1,0)

Hope it helps.

Marc.

datanibbler
Esteemed Contributor

Re: can any one send me expression attributes in a chart expression

Hi Venkat,

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.

Best regards,

DataNibbler

Not applicable

Re: can any one send me expression attributes in a chart expression


Hi DATANIBBLER,

i need to give colors to my pivot tables cells diffrent colors for each row based on dimension

can you help me on this .

Venkat

datanibbler
Esteemed Contributor

Re: can any one send me expression attributes in a chart expression

Hi,

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()) <<

HTH

Best regards,

DataNibbler