topic Re: Problem in Set Expression in QlikView

Problem in Set Expression

Frédéricdh — Tue, 30 May 2023 13:43:43 GMT

This Set Expression don't work.

= If(JW<=Year(Today(1) )& Week(Today(1))-4,Sum({<ORT={'vor Anlage'}>*<JW={ (Year(Today(1) )& Week(Today(1))) -4 }>} TOTAL BLEGW),Sum({<ORT={'vor Anlage'}>}BLEGW))

qlik don't want this <JW={ (Year(Today(1) )& Week(Today(1))) -4 }>, why?

thx in advance

Re: Problem in Set Expression

Kushal_Chawda — Tue, 30 May 2023 20:56:56 GMT

@Frédéricdh try putting double quotes around to evaluate

<JW={"= (Year(Today(1) )& Week(Today(1))) -4 "}>

Re: Problem in Set Expression

Frédéricdh — Wed, 31 May 2023 06:04:27 GMT

No it doesn't work

Re: Problem in Set Expression

Frédéricdh — Wed, 31 May 2023 08:03:00 GMT

it works, wenn you use this

<JW={"= &(=Year(Today(1) )& Week(Today(1)) -4) "}>