topic Re: Ceil - Error: Garbage after expression : "," in QlikView

Ceil - Error: Garbage after expression : ","

Thu, 18 Dec 2014 13:44:30 GMT

Hi guys,

Someone know what's up in this expression?

Ceil( Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)

I don't understand a mistake in Ceil =(

Thank you!

Re: Ceil - Error: Garbage after expression : ","

m_woolf — Thu, 18 Dec 2014 13:48:08 GMT

Have you looked at

Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week))

to see what it returns?

Re: Ceil - Error: Garbage after expression : ","

Aurelien_Martinez — Thu, 18 Dec 2014 13:49:35 GMT

Hi,

Try to add " on your set analysis like :

Ceil( Max( Aggr( Sum({1<Currency = {"$(=GetFieldSelections(Currency))"}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)

Aurélien

Re: Ceil - Error: Garbage after expression : ","

anbu1984 — Thu, 18 Dec 2014 13:52:01 GMT

Ceil( Max( Aggr( Sum({1<Currency = {"$(=Concat(Chr(39) & Currency & chr(39),','))"}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)

Re: Ceil - Error: Garbage after expression : ","

Thu, 18 Dec 2014 16:17:29 GMT

Thank you for all responses!

My expression working properly, but when I want to set a variable with my expression,I get an error in Ceil function as when I delete ',0.1', working properly!

Regards!

Re: Ceil - Error: Garbage after expression : ","

anbu1984 — Fri, 19 Dec 2014 02:54:07 GMT

It should work. Can you post sample app with Ceil issue

Re: Ceil - Error: Garbage after expression : ","

jagan — Fri, 19 Dec 2014 03:08:18 GMT

Hi,

This expression works properly, there is no issue with the parameter 0.1 to Ceil()

Ceil( Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)

It will round off to the next given level, assume that your expression returns 3.88 and 0.1 will 3.9

I think you forgot to give = in variable. Give = infront of the expression.

Regards,

Jagan.

Re: Ceil - Error: Garbage after expression : ","

jagan — Wed, 24 Dec 2014 01:38:40 GMT

Hi,

If you got the answer please close this thread by giving Correct Answer to the useful post, so that it would be helpful for others.

Regards,

Jagan.