topic Re: Expression returns a - rather than figure expected in QlikView

Expression returns a - rather than figure expected

Wed, 25 Nov 2020 16:16:04 GMT

I have a report I am trying to produce that shows our current stocks, packaging stocks and sales forecast.

I have setup a variable to give me current month which in my expression I divide by 4.3 to give me the forecast in weeks but for some reason it returns a -.

I've checked the link between the 2 tables and I can't see anything wrong there. If I just interrogate the forecast data I can return a figure which is correct but not using the variable.

It's going to be something simple but for the life of me I can't see what it is.

I've attached screenshots of the script and expressions etc. Any pointers in the right direction would be greatly appreciated.

Thanks Steve.

Re: Expression returns a - rather than figure expected

sunny_talwar — Wed, 08 Feb 2017 10:06:57 GMT

May be try this:

Sum({<Month = {'$(=vCurrentMonth)'}>} Forecast)/4.3

Re: Expression returns a - rather than figure expected

hector_munoz — Wed, 08 Feb 2017 10:09:01 GMT

Hi Steve,

Maybe the problem is in the set analysis of the expression... Try this expression:

Sum({$<Month={$(#vCurrentMonth)}>} Forecast) / 4.3

I hope it serves...

Regards,
H

Re: Expression returns a - rather than figure expected

Anonymous — Wed, 08 Feb 2017 10:10:29 GMT

Hi Steve,

Your Variable is called CurrentMonth but your set analysis is for vCurrentMonth.

Re: Expression returns a - rather than figure expected

Wed, 08 Feb 2017 10:33:24 GMT

Sorry that didn't change anything still showing -

Re: Expression returns a - rather than figure expected

Wed, 08 Feb 2017 10:33:47 GMT

Sorry that didn't change anything, still showing -

Re: Expression returns a - rather than figure expected

sunny_talwar — Wed, 08 Feb 2017 10:35:23 GMT

Can you check without the variable?/

Sum({<Month = {'$(=Month(Today()))'}>} Forecast)/4.3

Re: Expression returns a - rather than figure expected

Anil_Babu_Samineni — Wed, 08 Feb 2017 10:36:16 GMT

Image showing Variable as CurrentMonth not the vCurrentMonth

Try with it

Sum({<Month = {'$(=CurrentMonth)'}>} Forecast)/4.3

Re: Expression returns a - rather than figure expected

tresB — Wed, 08 Feb 2017 10:38:47 GMT

Should your variable be vCurrentMonth rather than vCurrentMonth ?

Re: Expression returns a - rather than figure expected

Wed, 08 Feb 2017 10:49:17 GMT

Thanks Anil, that worked.

Regards Steve