Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Group By Question

Hi,

I have about 35 fields in a concatenated table (bills and positions).
Does it make sense to add a group by statement if I don't need all of the single positions per bill (only the sum(amount) ? Or is there a better way to get handle this?
I'm thinking about this because of a performance issue, processing is quite slow.
Thanks for your ideas.

Regards Aloah

Tags (1)
4 Replies
Highlighted
Creator III
Creator III

Group By Question

Hi Aloah,

I think you ansered your question yourself. The group by statement seems very useful in your case.

Only select the 2 fields that you need and make a group by clausule as follows:

Bills:
LOAD Billnr,
sum(amount)
RESIDENT Bills // Note that this option is for either source system suitable
Group by Billnr;

STORE * FROM Bills INTO Bills.qvd;

Highlighted
Not applicable

Group By Question

Hi,

thanks for your reply. My problem is that I need more than two (in fact about 30 fields) from the tables.
In this case I'm having group by statement with 30 fields. Does that make sense?

Regards

Aloah

Highlighted
Creator III
Creator III

Group By Question

it does work however, i dont know whether it is the best way to do it.

I think if you group by multiple fields you have to keep in mind that all the fields have to keep fixed values in each row.

Highlighted
Not applicable

Group By Question

I have these tables.

%Pos_id
%Pos_number
%Pos_Article
......
Pos.Amount

%Pos_Article is linked to the article tables.

Every position has severals positionnumbers with different articles. Group by doesn't make sense as long as the articles and pos_numbers are in there.

If I use sum (Pos.Amount) and group by %Pos_id, %Pos_number, %Pos_Article.... the result will be (almost) the same as without group by.
I think I'll have to kick out the position numbers and articles? Am I right?

Thanks