How do I solve this?

[Remco]

Hi,

Yesterday I also posted this in another section but it remains unanswered, probably the wrong section... The question I have is probably very simple but I am still new to Qlik. I have a table in which with a dimension I group. Then per group the calculation for log trendline should be made. I calculate the Log (x) and that is ok. But how do I get into this table the repeating values b & c that are calculated without the grouping in the table? It shows the results as a total but that does not help me. How is this done in Qlik?

Thank you very much!

[rubenmarin]

HI, if b and c were variables they should be accesibles by all rows, maybe you are loading them as field values, not realted the the model, or at least not related to the data rows where period and x are.

You can try using variables for b and c, so you can use ($(c)*LOG(x))+$(b)

Or maybe using TOTAL to ignoer chart dimensions: (Only(TOTAL c)*LOG(x))+Only(TOTAL b)

[Architect]

I believe use of Set parameters, more suitable here.

($(c)*LOG(x))+$(b).

[Remco]

If I use this: 

Only(TOTAL LINEST_M(PIVOTSALESPERFORMANCE,LOG(Periode_)))

It tells me that nested aggregation is not allowed

When using

$(LINEST_M(PIVOTSALESPERFORMANCE,LOG(Periode_)))

There is no error but also no result.

[rubenmarin]

If that's one of the values calculated in a text box it can be a variable with value "=LINEST_M(PIVOTSALESPERFORMANCE,LOG(Periode_))"

And $(VariableName) will return the calculated value.

Or also you can use $(=LINEST_M(PIVOTSALESPERFORMANCE,LOG(Periode_)))

[Remco]

Hi, I will try. What I expect is:

The calculation for b = LINEST_M(PIVOTSALESPERFORMANCE,LOG(Periode_))
The calculation for c = LINEST_B(PIVOTSALESPERFORMANCE,LOG(Periode_))

What I expect, for example in the line where PERIOD = 201702 and periode_ = 2 is, using the next formula: y = (c * LOG(x)) + b

y = (0,43323884 * 0,69314718055995) -0,00088061735
y = 0,299417663

[Remco]

In both cases, it stays empty:

What am I doing wrong?

[rubenmarin]

test_2 should not have the double quotes, I put them only to fix that the equal sign was part of the value of the variable

test_3 shouldn't be a variable, that's an example you can use directly on chart expression

[Remco]

OK, I expected that already... But if I change the variable, the issue maintains. If I use it as a straight as you mention I get a "garbage" error:

[rubenmarin]

Maybe it's beacuse it's returning a decimal value with comma, can you check adding single quotes to return as text and check the value?:

'$(=LINE....)'