Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table which just shows values from script

I just need to create a table like this just for the overview of some variables in my script code:

Category2013For Peter in August
Apples101
Bananas72

These four values are in variables called:

Set vApples2013 = 'Sum(Apples2013)'; // 10

Set vBananas2013 = 'Sum(Bananas2013)'; // 7

Set ApplesForPeter = 'Sum({($<month={August}>)} PetersAppleTable)'; // 1

Set BananasForPeter = 'Sum({($<month={August}>)} PetersBananaTable)'; // 2

So all I want to have is this excel-like table to show some variables from my script code:

Categotry2013For Peter in August
Apples=Sum(Apples2013)=Sum({($<month={August}>)} PetersAppleTable)
Bananas=Sum(Bananas2013)=Sum({($<month={August}>)} PetersBananaTable)

Is this possible?

2 Replies
swuehl
MVP
MVP

If the table layout is quite static, I think it would be easiest to just use a couple of text boxes to simulate a table (using background color etc).

You can evaluate your variables maybe like

=$(vApples2013)

in one of these text boxes.

Not applicable
Author

@swuehl: Your approach is a not-so-very-nice workaround. I'll use it if I don't find any other solution.

I'm looking for an approach like an inline table like:

Result:

Load * inline [
Category, 2013, For Peter in August
Apples, $(vApples2013), $(vApplesForPeter)
Bananas, $(vBananase2013), $(vBananasForPeter)
]
;

But I don't find a solution that the values are shown in the table.

See file in the attachment. Maybe you can make it work?