Solved: Region Total Need - Qlik Community

dineshm030 · ‎2020-02-19

Hi,

I need the overall total for all months.

Sep - 222443

..

Dec - 223443

The value should be coming like this.

Expression:

Sum({<Month,RegionDesc>}Sales_Value_Primary)/1000
+
Sum({<Month,RegionDesc>}Sales_Value_ManualAdjustments)/1000

kaushiknsolanki · ‎2020-02-19

try this,

Sum(total<RegionDesc> {<Month,RegionDesc>}Sales_Value_Primary)/1000
+
Sum(total<RegionDesc>{<Month,RegionDesc>}Sales_Value_ManualAdjustments)/1000

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2020-02-19

try this,

Sum(total<RegionDesc> {<Month,RegionDesc>}Sales_Value_Primary)/1000
+
Sum(total<RegionDesc>{<Month,RegionDesc>}Sales_Value_ManualAdjustments)/1000

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!