Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
giancarlo_satur
New Contributor II

Group By and Order By

Hello!!

I'am trying to add  A Group By and a Order By to my table, but i receive this error: ' Invalid Expression'

(the only expression is a sum(BankDebt))

Can You help me?

I attached the qvw.

Thanks

Giancarlo

It'S the correct file

9 Replies

Re: Group By and Order By

I didn't receive any error while reload. Will you provide snapshot for that error

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
giancarlo_satur
New Contributor II

Re: Group By and Order By

Hi Anil, i have uploaded the wrong file..now it is correct...
before the reload isn't break because in the Group By i have insert all dimensions :

Group by  BankGroup, BankDebt, DataAct

But i want only Bank Group in the Group By

lawrance
Contributor II

Re: Group By and Order By

Hi Saturno,

In group by we should use all the fields except aggregated field.

Could you please share the screenshot of that error.

Thanks,

Lawrance A

giancarlo_satur
New Contributor II

Re: Group By and Order By

error.JPG

Not applicable

Re: Group By and Order By

Are you  missing a comma after autonumber?

aarkay29
Valued Contributor

Re: Group By and Order By

Check this

giancarlo_satur
New Contributor II

Re: Group By and Order By

thanks but now i don't have any value?!?

giancarlo_satur
New Contributor II

Re: Group By and Order By

now comma is there..

aarkay29
Valued Contributor

Re: Group By and Order By

if this not what you are expecting. Please give a example what you are trying to achieve

Thanks.