topic Re: Set Analysis - Total in QlikView

Set Analysis - Total

Tue, 14 Apr 2015 02:34:01 GMT

Hello,

I am trying to calculate the Total Count (ignoring MEDIAGRP) for each TVGRP. I am expecting value 3 for the first 4 rows and value 4 for remaining rows in the last column.

Can you please help with SET expression. I tried below, but it did not work.

Count (TOTAL {<MEDIAGRP=>} DISTINCT PANEL_ID)

Thanks so much in advance.

Regards,

Saravanan

Re: Set Analysis - Total

ramoncova06 — Tue, 14 Apr 2015 02:41:38 GMT

switch the MEDIAGRP to TVGRP, that way the total only groups by TVGRP

Count (TOTAL {<TVGRP=>} DISTINCT PANEL_ID)

Re: Set Analysis - Total

Tue, 14 Apr 2015 04:35:29 GMT

Hi Ramon,

Thanks for the quick reply. Switching to TVGRP gives the aggregate of ALL TVGRPs (i.e. it populates 5 for all rows in last column). I need Total of ALL MEDIAGRPs by each TVGRP

Something else you can think of?

Regards,

Saravanan

Re: Set Analysis - Total

Tue, 14 Apr 2015 04:44:55 GMT

Hi Saravanan,

Can you share a sample .qvw

Thanks,

Harika

Re: Set Analysis - Total

PrashantSangle — Tue, 14 Apr 2015 04:45:26 GMT

Hi,

Try

Count (TOTAL<TVGRP> {<MEDIAGRP=>} DISTINCT PANEL_ID)

Regards

Re: Set Analysis - Total

Tue, 14 Apr 2015 04:51:29 GMT

Thanks Max, it worked

Re: Set Analysis - Total

Tue, 14 Apr 2015 04:55:18 GMT

Hi Harika, Attaching the file with solved example. Thanks