Straight table Separator and Delta Issue

[sampada0810]

Hi all,

I am having a straight table with few expressions and also separate expressions for the Delta Symbols, i.e. the Red and Green arrows.

But I want to club the expression with the delta symbol expression.

see the image below:

As I am having 2 expressions I am getting separators for both.

So I disabled the Vertical expressions borders in style tab.

And used Line object as a separator.

But with this approach the issue I am facing is,

If I select any one dimension, the data is getting reduced, but the lines are remaining as they are..very long, like this:

So either I need to handle the height of the line dynamically or some way out so that the expression and the delta symbol are in same expression.

Note: I want Red and Green Deltas only.

Please let me know if can get rid of this issue.

[marcus_sommer]

You could include these kind of arrows within the num() formatting-part from your expression unless the coloring of the arrows - either no color or coloring the whole cell.

- Marcus

[kaushiknsolanki]

Hi,

Why dont you combine both the expressions like below.

Sum(Sales) & ' ' & If(Condition,'qmem://<bundled>/BuiltIn/check.png','qmem://<bundled>/BuiltIn/cross_r.png')

Regards,

Kaushik Solanki

[Gysbert_Wassenaar]

Not if you want the numbers to be black and the deltas colored. Well, that's not true. You could create a load of text boxes that you show or hide depending on the number of rows your main chart will be showing as a result of the user selections. That way you can hide the lines by showing a text box on top of them.

[vinieme12]

Expression formatting is applied to the whole cell, you cannot format a part of the cells content

[vinieme12]

I think  cell can either be text or image , not both together.

The Representation i mean

[kaushiknsolanki]

Hi,

You can keep that as Text and it will work.

Regards,

Kaushik Solanki

[sampada0810]

For expression the representation is  Text and for Delta it is Image. So it cannot be clubbed like that.

[kaushiknsolanki]

Hi,

Can you give us the sample application.

Regards,

Kaushik Solanki

[vinieme12]

Hi Kaushik

Not working

Dummy dimension

valuelist('a')

Expression

=rangesum(1,2,3) & 'qmem://<bundled>/BuiltIn/led_b.png'

Using QV12 Sr4