topic Re: internal error set analysis on dynamic pivot table in QlikView

internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:04:18 GMT

I am trying to create a dynamic chart. I know how this works and I have done it before. But now I have the problem that I have set anlysis in my Expressions and it always says internal error.

for example:

expression: sum(#Menge) - sum({$<LfdNr = {$(=min(LfdNr))}>}#Menge)

msg from macro: sum(#Menge) - sum({$<LfdNr = {(internal error)}>}#Menge)

can someone please help me.

regards,

Re: internal error set analysis on dynamic pivot table

Sokkorn — Thu, 26 Jul 2012 10:10:49 GMT

Hi MT,

Let try this =sum(#Menge) - sum({$<LfdNr = {"=$(=min(LfdNr))"}>} [#Menge])

Do let me know.

Regards,

Sokkorn

Re: internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:10:52 GMT

try with ""

sum(#Menge) - sum({$<LfdNr = {"$(=min(LfdNr))"}>}#Menge)

Re: internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:12:52 GMT

I have already tried it.

now it looks like this:

msg from macro: sum(#Menge) - sum({$<LfdNr = {''}>}#Menge)

Re: internal error set analysis on dynamic pivot table

Sokkorn — Thu, 26 Jul 2012 10:14:50 GMT

Hi MT,

Can you share your app? It can be easy to find the root cause.

Regards,

Sokkorn

Re: internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:17:25 GMT

this is my table FormelName is shown in a listbox where you can choose what expression will be shown in the pivot table.

Formeln:

LOAD * Inline [

FormelName, Formel

Umsatz Stk, sum(#Menge) - sum({$<LfdNr = {$(=min(LfdNr))}>}#Menge)

1. Bestand, sum({$<#Date = {'$(=min(#Date))'}>}#Bestand)

Endbestand, sum({$<#Date = {'$(=max(#Date))'}>}#Bestand)

LUG, ((sum(#Menge) - sum({$<LfdNr = {$(=min(LfdNr))}>}#Menge))/((sum({$<#Date = {'$(=min(#Date))'}>}#Bestand) + sum({$<#Date = {'$(=max(#Date))'}>}#Bestand))/2))*(52/(max(LfdNr) - min(LfdNr)))

];

do you want to see the macro?

Re: internal error set analysis on dynamic pivot table

Sokkorn — Thu, 26 Jul 2012 10:26:40 GMT

Hi MT,

Load all your formula like this;

Formeln:

LOAD * Inline [

FormelName, Formel

Umsatz Stk, sum(#Menge) - sum({$<LfdNr = {"=$(=min(LfdNr))"}>} [#Menge])

];

Your expression should be =$(Formel)

Did you try this yet?

Regards,

Sokkorn

Re: internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:35:46 GMT

sum(#Menge) - sum({$<LfdNr = {=(=min(LfdNr))}>}#Menge) this seems to work and

sum(#Menge) - sum({$<LfdNr = {(=min(LfdNr))}>}#Menge) that too. but now i have the problem that my chart is not beeing built

Re: internal error set analysis on dynamic pivot table

Sokkorn — Thu, 26 Jul 2012 10:38:24 GMT

Hi MT,

What dimension and expression you used? It would be great, if you can share your app.

Regards,

Sokkorn

Re: internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:39:48 GMT

i think it is too big to share. if i use this expression directly in the chart it works fine but if im trying it dynamicly there are problems

Re: internal error set analysis on dynamic pivot table

Thu, 26 Jul 2012 10:49:46 GMT

this is what my app is based on:::so maybe we can work it out on that example cause mine is just too big to upload

Re: internal error set analysis on dynamic pivot table

Mon, 30 Jul 2012 07:54:05 GMT

I solved the problem...I enable and disable the formular in the macro now!! The set analysis works fine now.