topic Re: Syntax Set Analysis in QlikView

Syntax Set Analysis

Mon, 10 Nov 2014 19:31:07 GMT

hi i am battling with the following statement

Sum({[Ar Vecka] = {" >=$( = max(År)-1 & week(max(Datum))) - VeckaAckSäsong)) <= $(=max(År)-1 & week(Max(Datum)))"}>}

Nettobelopp)

. i recieve no error message but still the value is shown as -

i would like state that VeckaAckSäsong is a number son in this case 12 which leaves we with the date 201444 - 12 = 201432 and the other date as 201444.

my goal is to find the interval between these two values.

any help is greatly appreciated .

Best

Brad

Re: Syntax Set Analysis

shree909 — Mon, 10 Nov 2014 19:38:55 GMT

Hello,

If possible could you please attach a sample , so that i can dig into that.

Please replace the " >=$( = max(År)-1 & week(max(Datum))) - VeckaAckSäsong)) <= $(=max(År)-1 & week(Max(Datum)))"} " with the actual values and test it.

Thanks

Re: Syntax Set Analysis

Mon, 10 Nov 2014 19:53:37 GMT

i have attached a test

you will see the interval there 201332 - 201344. i have tried replacing the values without sucess.

Best

Brad