Solved: Please help with format.. And thanls in advance - Qlik Community

Report Inappropriate Content · ‎2011-02-10

Report Inappropriate Content · ‎2011-02-10

I don't think you can change the description of the subtotal based on a description. I think those are generated before the detail of the chart, so it is all or nothing.

As for the color, you should be able to do that using a Background Expression and Dimensionality(). First, add Dimensionality() as an expression to your chart and note the number for that area. Then for your Background Expression, use:

If(Dimensionality()=# and EA Espana Expression < 0, rgb(255,0,0))

You may have to tweak it a bit, but that's the idea.

View solution in original post

Report Inappropriate Content · ‎2011-02-10

I don't think you can change the description of the subtotal based on a description. I think those are generated before the detail of the chart, so it is all or nothing.

As for the color, you should be able to do that using a Background Expression and Dimensionality(). First, add Dimensionality() as an expression to your chart and note the number for that area. Then for your Background Expression, use:

If(Dimensionality()=# and EA Espana Expression < 0, rgb(255,0,0))

You may have to tweak it a bit, but that's the idea.

Report Inappropriate Content · ‎2011-02-10

dosen't work

matt_crowther · ‎2011-02-11

Your 2nd question can be solved in the follwoing manner:

set the Text Colour or Background Colour expression of 'EA Espana' to:

=if([EA Espana]<0 and isnull(rowno()),rgb(255,198,198))

That works for me.

As for the 1st issue: are you trying to get the 'Subtotal' to be dynamic to show say 'Gastos Personal Subtotal', 'Financieros Subtotal' etc?

Hope that helps with point 2,

Matt - Visual Analytics Ltd