Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Contributor II

## Show a Text as Expression

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 Actual Actual Budget Budget Budget Budget Budget Budget Budget Budget Budget Revenue Name 1 Name 1 b Revenue Name 1 Name 1 c Revenue Name 2 Name 2 Revenue Name 3 Name 3 a
1 Solution

Accepted Solutions
Contributor II
Author

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.

2 Replies
MVP & Luminary

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

- Marcus

Contributor II
Author

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.

Community Browser