topic Calculated Row on in Straight Table in QlikView

Calculated Row on in Straight Table

Tue, 22 Nov 2011 06:43:47 GMT

Hello All,

The problem i am facing is that i have a segment column which i am using as a dimension

the values to segment dimension is

Segment

-------------

D1-D3

D4-D6

NCP

Now i need to show sum of some metric for each of these segments which is not a problem

I also need to show one more calculated row as ALL CP which is a summation of (D0,D1-D3,D4-D6)

So finally it should come out to be like

Segment

-------------

D1-D3

D4-D6

All CP (Sum of D0, D1-D3,D4-D6)

NCP

Calculated Row on in Straight Table

Tue, 22 Nov 2011 06:56:11 GMT

Pls try this..........

Tab A:

Segment

from .....

concatenate load

if(Segment='D0' or Segment='D1-D3'or Segment='D4-D6','All CP') as Segment

Resident Tab A;

Regards,

Antony.

Calculated Row on in Straight Table

Tue, 22 Nov 2011 07:20:01 GMT

Thanks i could do that, however

the problem i am facing now is that the metric is not pre calculated so say

Earlier

---------

Segment Calles_Made<sum(calls)>

------------ -------------------

D0 56

D1-D3 72

NCP 52

Now i Get

Segment Calls_Made

----------- ------------------

D0 56

D1-D3 72

All CP 0
NCP 52

How would i get to precalculates the sum of calls for All CP?

Geo_Calls:

LOAD Geo_Calls_Data.GeoID,

Geo_Calls_Data.Segment,

Reach,

calls

FROM

Geo_Calls_Data.qvd

(qvd);

concatenate load

if(Geo_Calls_Data.Segment='D0' or Geo_Calls_Data.Segment='D1-D3'or Geo_Calls_Data.Segment='D4-D6','All CP') as Geo_Calls_Data.Segment

Resident Geo_Calls;

Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:32:37 GMT

sum(if(Geo_Calls_Data.Segment='D0' or Geo_Calls_Data.Segment='D1-D3'or Geo_Calls_Data.Segment='D4-D6',Reach)) as Reach

this does not seem to work

netiher does sum(reach) as a sub query in the if query

What else can i do?

Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:34:08 GMT

pls share your application....

Re: Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:47:39 GMT

Please find attacment....

Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:50:08 GMT

I so desperately wanted to.. but data behind is not sanitized and am not authorized to share it with the actual data.

A simple question...

So my table has

Segment reach Calls

----------- ----------- ---------

D0 23 78

D1-D3 67 89

NCP 78 89

Now what i want as an output is

Segemnt Reach Calls

----------- ------------ --------

D0 23 78

D1-D3 67 89

All CP 90 167

NCP 78 89

What i cant understand is why the aggregartion of the metric throwing an error? in the concatenate script?

If you want i can prepare mock data if it wud help?

Re: Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:51:23 GMT

i have attached one application on above, pls check.

Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:54:31 GMT

Thanks for the example , i ve got the idea shall just try and get back to you,

Thank you so much

Regards,

Prateek

Calculated Row on in Straight Table

Tue, 22 Nov 2011 09:59:37 GMT

Hello Antony,

Thanks a lot, works pretty well.

Regards,

Prateek

Re: Calculated Row on in Straight Table

Tue, 22 Nov 2011 10:00:40 GMT

Thanks ....

Regards,

Antony