topic Re: Straight table Separator and Delta Issue in QlikView

Straight table Separator and Delta Issue

sampada0810 — Tue, 13 Dec 2016 07:34:57 GMT

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.

Re: Straight table Separator and Delta Issue

marcus_sommer — Tue, 13 Dec 2016 07:41:11 GMT

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

Re: Straight table Separator and Delta Issue

kaushiknsolanki — Tue, 13 Dec 2016 07:43:55 GMT

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

Re: Straight table Separator and Delta Issue

Gysbert_Wassenaar — Tue, 13 Dec 2016 07:44:02 GMT

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.

Re: Straight table Separator and Delta Issue

vinieme12 — Tue, 13 Dec 2016 08:03:16 GMT

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

Re: Straight table Separator and Delta Issue

vinieme12 — Tue, 13 Dec 2016 08:04:06 GMT

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

The Representation i mean

Re: Straight table Separator and Delta Issue

kaushiknsolanki — Tue, 13 Dec 2016 08:25:32 GMT

Hi,

You can keep that as Text and it will work.

Regards,

Kaushik Solanki

Re: Straight table Separator and Delta Issue

sampada0810 — Tue, 13 Dec 2016 09:02:45 GMT

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

Re: Straight table Separator and Delta Issue

kaushiknsolanki — Tue, 13 Dec 2016 09:04:37 GMT

Hi,

Can you give us the sample application.

Regards,

Kaushik Solanki

Re: Straight table Separator and Delta Issue

vinieme12 — Tue, 13 Dec 2016 09:11:32 GMT

Hi Kaushik

Not working

Dummy dimension

valuelist('a')

Expression

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

Using QV12 Sr4