topic Re: Group By Clause in QlikView

Group By Clause

Anonymous — Wed, 29 Oct 2014 15:29:35 GMT

I am trying to use Group By but not getting the desired results. Can you tell me what is wrong in the script.

The sheet object is a table box. Qty and Sales Amount is supposed to total but its not doing that. Any help would be appreciated. thanks

Re: Group By Clause

jpenuliar — Wed, 29 Oct 2014 15:37:56 GMT

if you wan to have total in an Object, try using a chart instead of table box,

the group by in your script may not be necessary

Re: Group By Clause

MK_QSL — Wed, 29 Oct 2014 15:39:22 GMT

Temp:
Load Product, type, customer, [Sales Amount], Qty From TableName;

Final:
Load type, Customer, Sum([Sales Amount]) as TotalAmount, Sum(Qty) as TotalQty Resident Temp Group By type, Customer;

Drop Table Temp

Re: Group By Clause

Anonymous — Fri, 31 Oct 2014 01:53:26 GMT

Thank you Manish. Your reply cured the mistake I was making. I am getting to know Qlikview logics now. I am even liking it!

Re: Group By Clause

Anonymous — Wed, 05 Nov 2014 15:33:24 GMT

hi All, I am trying to understand optimization whereever applicable. So in this case, precalculating values is better practice than using more expressions. As illustrated here, Table box precalculates sum for qty and revenue. Whereas In pivot table (or any other chart) I am using 2 expressions. so performance wise, table box is better than pivot table if total of qty and sales only were needed. this would specifically be true if there were millions of records. Correct..? Also, I want to make sure what precalculation is. So am I right about script for Table box being it..?