Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
giancarlo_satur
Contributor II
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
Anil_Babu_Samineni

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

giancarlo_satur
Contributor II
Contributor II
Author

error.JPG

Not applicable

Are you  missing a comma after autonumber?

aarkay29
Specialist
Specialist

Check this

giancarlo_satur
Contributor II
Contributor II
Author

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

giancarlo_satur
Contributor II
Contributor II
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.