topic Re: Group by with qlikview in QlikView

Group by with qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Group by with qlikview

swuehl — Wed, 01 Jun 2016 11:37:33 GMT

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.

Re: Group by with qlikview

Wed, 01 Jun 2016 11:39:20 GMT

Is it possible to do it in a setexpression?

Re: Group by with qlikview

swuehl — Wed, 01 Jun 2016 11:42:28 GMT

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

Re: Group by with qlikview

sasiparupudi1 — Wed, 01 Jun 2016 11:43:05 GMT

yes Aggr

Aggr(count(field),GroupByDimens)

Re: Group by with qlikview

Peter_Cammaert — Wed, 01 Jun 2016 12:03:56 GMT

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