topic Straight table Expression (Image + Text) in QlikView

Straight table Expression (Image + Text)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi Team,

I have a straight table of Month and ABC as dimension and Fee as Expression.

Month	abc	Fee
Jul 2018	TQ	1,315
Jun 2018	TQ	1,516
May 2018	TQ	1,485
Apr 2018	TQ	1,219
Mar 2018	TQ	1,277
Feb 2018	TQ	1,368

I want the expression to have the value + image saving up or down direction compared to previous month like below:

Proposed Table

Month

abc

Fee

Jul 2018

1,314

Jun 2018

1,516

May 2018

1,484

Apr 2018

1,218

Mar 2018

1,276

Feb 2018

1,367

please help

thanks

Sukhwant

Re: Straight table Expression (Image + Text)

johnca — Wed, 15 Aug 2018 17:19:59 GMT

Your images don't show but maybe something like the attached?

Essentially, use Month and abc as dimensions and then these expressions;

Expression 1:

Sum(Fee)

Expression 2: Set Representation to Image

If(Sum(Fee) > Above(Sum(Fee)),'qmem://<bundled>/BuiltIn/arrow_n_g.png',

If(Sum(Fee) < Above(Sum(Fee)),'qmem://<bundled>/BuiltIn/arrow_s_r.png',

'qmem://<bundled>/BuiltIn/arrow_e.png'

))

For lack of a better sideways arrow showing no change I used the gray right arrow. You can use anything else or omit it.

The sort order seems to have a dramatic effect if you try to sort on the Month. I had to sort on abc in order for it to work.

HTH,

John

Re: Straight table Expression (Image + Text)

trdandamudi — Wed, 15 Aug 2018 17:43:45 GMT

One more option where you can use the arrow in the same cell as the value is as below:

Dimensions:

Month

abc

Expression:

                         =Sum(Fee) &' ' &If(Sum(Fee) > Above(Sum(Fee)),chr(8593),
                                If(Sum(Fee) < Above(Sum(Fee)),chr(8595),Chr(8596)
                            ))