Set Analysis - restricting other sub-selections on other fields

johnhorneramllp — Sat, 11 Jul 2009 10:21:16 GMT

I have what appears to be a very simple Set Analysis requirement that i cannot seem to get to work the way i would like. In the attached document i would like Measure 1 A to always total 11 and always show the rows for Dim2 = AAA = 5 and Dim2 = BBB = 6. My Set Analysis is very simple, Sum({<Dim1 = {A}>} Measure1). This works fine for all selections in Dim1, however as soon as i select Dim2 = AAA then i lose the results for Dim2 = AAB, even though AAB is still part of the Set Dim1 = A.

I know i can fix this by adding a SET for Dim2 = {*} but in the real world that would mean that i would have to add a similar set for every field in which the user could possibly make selections and this i do not want to do.

Anyway, perhaps somebody has a better idea of how to do this than me.

John H

Set Analysis - restricting other sub-selections on other fields

Sat, 11 Jul 2009 20:31:01 GMT

If you want it to alway show the same results, force it to all data:

Sum({1<Dim1={A}>} Measure1)

Set Analysis - restricting other sub-selections on other fields

johnhorneramllp — Sun, 12 Jul 2009 00:28:34 GMT

Thanks Tom, every day is a school day!

Regards

John H

topic Set Analysis - restricting other sub-selections on other fields in QlikView

Set Analysis - restricting other sub-selections on other fields

Set Analysis - restricting other sub-selections on other fields

Set Analysis - restricting other sub-selections on other fields