Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax Set Analysis

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

2 Replies
shree909
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

i have attached a test

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

Best

Brad