- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Straight table Separator and Delta Issue
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
talk is cheap, supply exceeds demand
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression formatting is applied to the whole cell, you cannot format a part of the cells content
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think cell can either be text or image , not both together.
The Representation i mean
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can keep that as Text and it will work.
Regards,
Kaushik Solanki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For expression the representation is Text and for Delta it is Image. So it cannot be clubbed like that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you give us the sample application.
Regards,
Kaushik Solanki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Kaushik
Not working
Dummy dimension
valuelist('a')
Expression
=rangesum(1,2,3) & 'qmem://<bundled>/BuiltIn/led_b.png'
Using QV12 Sr4
If a post helps to resolve your issue, please accept it as a Solution.