topic Table which just shows values from script in QlikView

Table which just shows values from script

Wed, 16 Oct 2013 15:39:08 GMT

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

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:

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

Is this possible?

swuehl — Wed, 16 Oct 2013 15:56:59 GMT

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.

Wed, 16 Oct 2013 16:15:14 GMT

@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?