topic Re: Set expression not working returning '0' in QlikView

Set expression not working returning '0'

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone

I've been trying to get below set expression to work. However, I can figure out what I'm doing wrong.

As you can see, the first Set Expression is concerning Months, and the second is concerning Year.

Can it be something with the structure of the datafield AD_CAL_MONTH? It contains the data 01,02.....12.

I hope that someone can help

Stefan

manideep78 — Tue, 25 Apr 2017 13:33:42 GMT

add this instead of AD_CAL_MONTH

(=only(num(AD_CAL_MONTH,'#'))-1)

Anonymous — Tue, 25 Apr 2017 13:38:04 GMT

It still returns '0'

Sum({$<AD_CAL_MONTH={$(=only(num(AD_CAL_MONTH,'#'))-1)}>}if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA' , New_NET))

manideep78 — Tue, 25 Apr 2017 13:44:41 GMT

what is the expected output and can u post the sample app??

also what is the data that present in AD_CAL_YEAR field?

sunny_talwar — Tue, 25 Apr 2017 13:48:12 GMT

Are you selecting a single AD_CAL_MONTH? May be try this

Sum({$<AD_CAL_MONTH = {$(=Num(Max(AD_CAL_MONTH)-1, '00'))}, CUSTOMER.CGRNO -= {'IA', 'KA', 'BA'}>} New_NET)

Anonymous — Tue, 25 Apr 2017 13:53:13 GMT

Hi Sunny

That worked perfectly thanks

And Manideep thanks for your suggestion to.

Best

Stefan

sunny_talwar — Tue, 25 Apr 2017 13:57:46 GMT

No problem

manideep78 — Tue, 25 Apr 2017 14:02:34 GMT

mark the correct answer and close the thread 🙂

Anonymous — Tue, 25 Apr 2017 14:08:30 GMT

There is NO green star "Correct Answer" to click?!