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

can any one send me expression attributes in a chart expression

Thu, 06 Nov 2014 12:44:54 GMT

Hi all,

Greetimg for the day,

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

Thanks,

Venkat

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

Anonymous — Thu, 06 Nov 2014 12:49:14 GMT

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.

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

datanibbler — Thu, 06 Nov 2014 12:50:37 GMT

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

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

Thu, 06 Nov 2014 13:00:38 GMT

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

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

datanibbler — Thu, 06 Nov 2014 13:10:51 GMT

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