Group by with qlikview

[#1]

Hey guys,

I have a table with daily buys and sells and I would like to group every a table by currencies. Is that possible?

Group by currency in SQL so to speak.

[swuehl]

In the script, you can use a GROUP BY clause in you LOAD statements, just like in SQL.

In the chart, use Currency as dimension to group your expression results.

[#3]

Is it possible to do it in a setexpression?

[swuehl]

A set expression is filtering the record set that is used in the aggregation, while a GROUP BY is grouping your records, so these are kind of different things:

The Aggregation Scope

[sasiparupudi1]

yes Aggr

Aggr(count(field),GroupByDimens)

[Peter_Cammaert]

If you want to group buys & sells by currency in the same table chart, add the currency field as a dimension. Pivot tables are very handy here.

If you want to group Buys & Sells by currency with each in a different table, you can use set analysis although the number of charts will not automatically follow the number of currencies.

If you can display your Buys & Sells as graphs (line chart), you can use a third option which is to add currency as a Trellis dimension. That's a truly dynamic solution.

Peter