topic Re: Error in expression - Garbage after expression in QlikView

Error in expression - Garbage after expression

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

Hi,

I am getting the following message "Garbage after expression:")"

By process of elimination I have narrowed the problem down to the expression:

=Num(RangeSum(Above(sum(SKH_Quantity), 0, rowno())))/2

The issue only arises when no selection of an item is made.

Any ideas?

Thanks

Shamit

Re: Error in expression - Garbage after expression

sunny_talwar — Thu, 02 Jun 2016 00:14:10 GMT

May be this:

=Num(

RangeSum(

Above(

Sum(SKH_Quantity), 0, RowNo()

)

)/2

)

Re: Error in expression - Garbage after expression

sunny_talwar — Thu, 02 Jun 2016 00:14:55 GMT

This works when selection in item is made? Is this only part of the expression?

Re: Error in expression - Garbage after expression

shamitshah — Thu, 02 Jun 2016 00:27:28 GMT

Hi Sunny,

I get results when I pick an item from the selection box, but when there is no selection the message pops up.

I tried your suggestion above but still having the same issue.

Thanks

Shamit

Re: Error in expression - Garbage after expression

sunny_talwar — Thu, 02 Jun 2016 00:41:21 GMT

Would you be able to post snapshots of with and without selection?

Re: Error in expression - Garbage after expression

shamitshah — Thu, 02 Jun 2016 01:01:42 GMT

Hi Sunny,

These are the expression in the table:

Movement: sum({<PeriodType={'Current'}>}SKH_Quantity)

M/E Balance: sum({<PeriodType={'Current'}>}SKH_Quantity)

Avg Stock: =Num(RangeSum(Above(sum(SKH_Quantity), 0, rowno())))/2

Stock Turn: =NUM(sum({<PeriodType={'Current'},SKH_Source={'SO'}>}SKH_Quantity)*-1)-sum({<PeriodType={'Current'},SKH_Reference={'RA*'}>}SKH_Quantity)/(num(RangeSum(Above(Sum(SKH_Quantity), 0, rowno())))/2)

SO:sum({<PeriodType={'Current'},SKH_Source={'SO'}>}SKH_Quantity)*-1

RA:=NUM(sum({<PeriodType={'Current'},SKH_Source={'SO'}>}SKH_Quantity)*-1)-num(sum({<PeriodType={'Current'},SKH_Reference={'RA*'}>}SKH_Quantity))

Without any selection:

Selection of an item:

Thanks

Shamit

Re: Error in expression - Garbage after expression

sunny_talwar — Thu, 02 Jun 2016 02:07:43 GMT

You marked my above response as correct, is the issue resolved now?

Re: Error in expression - Garbage after expression

shamitshah — Fri, 03 Jun 2016 01:12:35 GMT

Yes, thanks Sunny.

Shamit

Re: Error in expression - Garbage after expression

sunny_talwar — Fri, 03 Jun 2016 01:36:56 GMT

Awesome