Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Simple Group By

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!

ScreenHunter_03 Jun. 11 19.35.gif

Tags (3)
1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: Simple Group By

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

4 Replies
Sokkorn
Honored Contributor

Re: Simple Group By

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

Not applicable

Re: Simple Group By

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

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

Not applicable

Re: Simple Group By

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

Community Browser