topic Re: setanalysis sum calculation fo selected date in QlikView

setanalysis sum calculation fo selected date

srinivasa1 — Thu, 25 Apr 2013 15:22:57 GMT

I have 2 set of date one is sondate and other is Actualdate as like below

Header 1	Header 2	Header 3	Header 4
Product	Asondate	Actualdate	Amt
A	2/26/2011	1/31/2011	100
A	2/26/2011	2/16/2012	200
B	3/31/2013	1/31/2013	1500
B	3/31/2013	2/28/2013	100
B	3/31/2013	3/31/2013	200

If I select As on Date 2/26/2011 then need to
calclulate sum of Actual date (1/31/2011+2/16/2012) it should be 300 can any suggest how I can
achive this in setanalysis

Thanks

Re: setanalysis sum calculation fo selected date

calvindk — Thu, 25 Apr 2013 15:45:58 GMT

If i understand correctly, what you want is Sum(Total <Asondate> Amt) as an expression in that chart

Re: setanalysis sum calculation fo selected date

srinivasa1 — Thu, 25 Apr 2013 16:01:17 GMT

Thanks for reply.

If i select as on date 2/26/2011 fromlist box

Then total should be sum of Actual date Eg

1/31/2011 + 2/16/2012=300

Thanks

Re: setanalysis sum calculation fo selected date

Thu, 25 Apr 2013 16:29:46 GMT

HI ,

You wanted the OutPut in the Straight Chart table ?

If so then have only Product and AsOnDate in the Dimension and try to have only sum(Amt) in the Expression.

If not then how you wantd to be seen in which object?

Please correct me.

//Yusuf

Re: setanalysis sum calculation fo selected date

srinivasa1 — Thu, 25 Apr 2013 16:32:01 GMT

Im useing pivot table.in list box Asondate selected then total should be sum of actual date belongs to Asondate

Thanks

Re: setanalysis sum calculation fo selected date

calvindk — Thu, 25 Apr 2013 19:28:19 GMT

Did you try Sum(Total <Asondate> Amt) ?