Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anil_Babu_Samineni

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

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
Author

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
Creator II
Creator II

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

Anonymous
Not applicable
Author

error.JPG

Not applicable
Author

Are you  missing a comma after autonumber?

aarkay29
Specialist
Specialist

Check this

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

now comma is there..

aarkay29
Specialist
Specialist

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

Thanks.