topic AW:Re: AW:Re: Declare Variable with SET Statment in QlikView

Declare Variable with SET Statment

chrisg — Thu, 20 Jan 2011 08:10:38 GMT

Hi,

i would like to declare a var. with the SET Statment

SET VAR == SUM({$<MONTH = {"<=$(=max(MONTH))"},KONTO={'Umsatz'}>} Periode)

But i do have the problem that i get for the Part "<=$(=max(MONTH))" a {"<=(internal error)"}

Any hinds

many thx

Chris

Declare Variable with SET Statment

Thu, 20 Jan 2011 08:22:38 GMT

With SET you are setting a string value. With LET you are calculating what is behind the equals sign. So most likely all you have to do is change an S for an L and you're fine to go 🙂

AW:Re: Declare Variable with SET Statment

chrisg — Thu, 20 Jan 2011 08:54:24 GMT

many thx - but i am afraid this does not wok for me:-(

FIRST:

Aggregation expressions not allowed in GROUP BY clause

LET Var = sum({$<Month = {"<=(internal error)"},KONTO={'Umsatze}>} Periode)

and the "<=(internal error)" is still there

Chris

AW:Re: Declare Variable with SET Statment

tresB — Thu, 20 Jan 2011 09:49:08 GMT

Hi,

it seems that you are working at script level. Set Analysis can't be used in script. it is used to play with Selection in front end.

regards, tresesco

AW:Re: AW:Re: Declare Variable with SET Statment

chrisg — Thu, 20 Jan 2011 10:07:23 GMT

Hi Tresesco, many thx - i do have a lot of very long formulars in my document. the idea was to work with vars. I try to declare a var over the menue (Varlist) - that worked without a problem!? But i do not want to use the editor for that. thx Chris

AW:Re: AW:Re: Declare Variable with SET Statment

tresB — Thu, 20 Jan 2011 10:16:31 GMT

So the problem is that, Max(MONTH) is not working. right? Can you test this part in the text object, and check what the output is coming?

AW:Re: AW:Re: AW:Re: Declare Variable with SET Statment

chrisg — Thu, 20 Jan 2011 10:23:45 GMT

Hi,

that works! - pls see my picture

Chris

AW:Re: AW:Re: AW:Re: Declare Variable with SET Statment

Thu, 20 Jan 2011 11:40:51 GMT

Hello Chris, (hi tresesco),

in my oppinion the $()-expansion is the thing you are struggling with. This feature can be used in expressions, but also in the script. And your problem is that this replacement is done automatically when the "$(=" appears (somewhere) in the script code. But in your special case QV should do no expansion.

With this in mind I searched for a workaround e.g. using [ ] and ' ', but in vain. The only raw Idea is this:

SET DOLLAR= '$(=';

SET VAR == SUM({$<MONTH = {"<= $(DOLLAR) =max(MONTH))"},KONTO={'Umsatz'}>} Periode);

Yes, It looks a bit strange. Without 'Umsatz' another solution would be using LET and stringconcat like LET VAR = '... ' & '$' & '......';

Regards, Roland