Set Analysis and Sum Group

Mon, 06 Oct 2014 19:53:41 GMT

Hello there,

I am using set analysis on most of my reports but I have come across the following issue:

- How can I replicate the result of this formula "Sum(qty)/Sum(TOTAL<Year,Style>qty) in set analysis?

I have the following formula: Sum({<Year=,Month=>}qty) (of course the reason for using set analysis is a little more complex but basically I need to show the % per each style total besides the actual total.

any help is greatly appreciated.

Thanks,

Hugo

topic Set Analysis and Sum Group in QlikView

Set Analysis and Sum Group