topic Set Analysis - Sum by Dimension B when Dimension A selected in QlikView

Set Analysis - Sum by Dimension B when Dimension A selected

mazacini — Wed, 16 May 2012 21:30:25 GMT

I have 3 fields Date, Week and Val

In my table I have an expression sum(Val). When I select Date, it will sum the Val for that Date.

I want to add another expression to sum the Val for all Dates in the Week corresponding to the selected Date.

Any ideas

Joe

Jason_Michaelides — Wed, 16 May 2012 22:18:03 GMT

I'm not sure if this will work without Week being a dimension in your chart, but try:

Sum(TOTAL <Week> Value)

If not, try:

Sum({<Date=, Week=P()>} Value)

Hope this helps,

Jason

mazacini — Wed, 16 May 2012 23:15:14 GMT

Hi Jason

Thanks for that.

First one didn't quite work.

Second one seems to work fine!

But I do seem to be getting a syntax error:

Sum({<Date=, Week=P()>} Val)

Any ideas on what might be causing this, or is it safe to procveed?

Joe

Jason_Michaelides — Thu, 17 May 2012 06:48:38 GMT

Safe to go I'd think. The syntax checker was new to v10 and is a little flaky within set analysis although generally one of the best enhancements!