Sort by Value (sql Group by)

[#1]

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

[PrashantSangle]

Yes,

Group by is present in qlikview.

For details see help menu

Regards,

[avinashelite]

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

[ciaran_mcgowan]

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.