Discussion Board for collaboration related to Creating Analytics for QlikView.
If I select As on Date 2/26/2011 then need tocalclulate sum of Actual date (1/31/2011+2/16/2012) it should be 300 can any suggest how I canachive this in setanalysis
If i understand correctly, what you want is Sum(Total <Asondate> Amt) as an expression in that chart
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
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.
Im useing pivot table.in list box Asondate selected then total should be sum of actual date belongs to Asondate
Did you try Sum(Total <Asondate> Amt) ?