topic Re: Group By and Order By in QlikView

Group By and Order By

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

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

Anil_Babu_Samineni — Fri, 23 Jun 2017 14:17:05 GMT

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

Anonymous — Fri, 23 Jun 2017 14:23:04 GMT

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 — Fri, 23 Jun 2017 14:24:36 GMT

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 — Fri, 23 Jun 2017 14:26:22 GMT

Fri, 23 Jun 2017 14:31:13 GMT

Are you missing a comma after autonumber?

aarkay29 — Fri, 23 Jun 2017 14:38:25 GMT

Check this

Anonymous — Fri, 23 Jun 2017 14:43:06 GMT

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

Anonymous — Fri, 23 Jun 2017 14:43:41 GMT

now comma is there..

aarkay29 — Fri, 23 Jun 2017 16:07:25 GMT

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

Thanks.