Show a Text as Expression

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

I'm have created a PivotTable with 3 dimensions and 2 expressions that sum the Actual and the Budget amount of the MaxMonth of Actuals it means last month closed.

----Budget Sum for max month with actuals 
=sum({<Chart={'Actual'}, Status={'BU 2017'}, Month={'$(vMaxMonthA)'}, Year={'$(vMaxYear)'}>}Amount)

And I have a file with the remarks or comments of each month for the delta but I can't make it show the corresponding remarks without selecting the month. I don't want to do that because I have to Pivots this wich should show the reamarks with the same condition as the sum, is there any way?

Last Closed Month

P&L	Name	Type	Actual	BU	Δ	Remarks
Revenue	Name 1	Name 1 a	100	110	-10	aaaaa
Revenue	Name 1	Name 1 b	300	280	20	bbbbb
Revenue	Name 1	Name 1 c
Revenue	Name 2	Name 2
Revenue	Name 3	Name 3 a

FYP

P&L

Name

Type

2017

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

Revenue

Name 1

Name 1 a

Chart

Actual

Budget

Revenue

Name 1

Name 1 b

Revenue

Name 1

Name 1 c

Revenue

Name 2

Revenue

Name 3

Name 3 a

Re: Show a Text as Expression

marcus_sommer — Fri, 28 Apr 2017 17:28:29 GMT

Try something like: only(Remarks) or maybe concat(Remarks, ' + ')

- Marcus

Re: Show a Text as Expression

marqupcmb — Fri, 28 Apr 2017 19:09:37 GMT

I did that but showed Remarks when it only exist in one month, I finally added a dimension as

=if(Month='$(vMaxMonthA)',Month)

and the expression Remarks

and now it shows the last month closed and if i pick a previous month the remarks of that month.

topic Show a Text as Expression in QlikView

Show a Text as Expression

Re: Show a Text as Expression

Re: Show a Text as Expression