topic Re: Simple Group By in QlikView

Simple Group By

Mon, 11 Jun 2012 23:41:33 GMT

I am a noob here when it comes to QlikView. But basically, I have some data that I need to group (after it's been loaded). So I have a simple Table Box as follows where I just want to group by "Tracking Code." Below is a screenshot of the box. Can anyone tell me in how in the properties for this report that I can make this group by tracking code, in order to sum unique visitors? Thanks!

Re: Simple Group By

Sokkorn — Tue, 12 Jun 2012 03:40:55 GMT

Hi jassonegan,

I'm not sure understood you well on this. But let try to create pivot table with

1. Tracking Code as dimension

2. SUM([Unique Visitors]) as expression

Regards,

Sokkorn

Re: Simple Group By

Tue, 12 Jun 2012 03:41:20 GMT

You should be using a chart object not table box. Table box displays the data as it is. Use a chart object with straight table where is automatically groups the data.

Cheers,

Kiran.

Re: Simple Group By

MayilVahanan — Tue, 12 Jun 2012 11:58:17 GMT

hi,

For presentation, use chart rather than table box, in chart, use straight or pivot table, use

Tracking code as dimension and

use Sum([Unique Visitors]) as expression.

It automatically group the Tracking code and gives the result .

Hope it helps

Re: Simple Group By

Tue, 12 Jun 2012 12:37:10 GMT

Thanks for the help there. The pivot table gave me what I needed.