topic Re: Sort by Value (sql Group by) in QlikView

Sort by Value (sql Group by)

Wed, 25 Nov 2020 16:16:04 GMT

Hi qlikviewers,

Is it possible to group by in qlikview? Like SQL getting a table for every unique specific value?

My issue is that I have millions of transactions. Imagine that table is just way to much text, it's to big to deal with. My dreamscenario is that if possible: I can sett a group by of some sort so it generates a table for every value that I set. For example by Country or something...

Thanks

Re: Sort by Value (sql Group by)

PrashantSangle — Mon, 27 Jun 2016 11:21:09 GMT

Yes,

Group by is present in qlikview.

For details see help menu

Regards,

Re: Sort by Value (sql Group by)

avinashelite — Mon, 27 Jun 2016 11:22:56 GMT

We have Group by feature in Qlikview but its not preferable for large data set

Check this example for how to use Group By

Group By Clause

Re: Sort by Value (sql Group by)

ciaran_mcgowan — Mon, 27 Jun 2016 11:27:18 GMT

Hi Niklas,

Yes there is a Group By function but it cannot be used during the initial load of data. It can only be used when using a Resident load.