topic Re: Subtotal wont come for calculated dimension in QlikView

Subtotal wont come for calculated dimension

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Appreciate if I am informed the steps to be followed, when a subtotal wont come for a calculated dimension! Please see below the data.

The total comes for last two columns are in correct.The formula used to get the subtotal of both new & renewals are too given below.

=IF(IF([Year(MakeDate('20'&(MID( POLICY_NO,5,2))))]<'2015','RENEWAL',IF([Year(MakeDate('20'&(MID( POLICY_NO,5,2))))]='2017','NEW',IF((Num(CR_MONTH)+365)-Num(RISK_MONTH)>365,'RENEWAL','NEW')))='RENEWAL',SUM(PREMIUM)*-1)

Thanks

Neville

Re: Subtotal wont come for calculated dimension

sunny_talwar — Sat, 19 Aug 2017 12:37:50 GMT

Try these guys

=Sum(Aggr(

IF(IF([Year(MakeDate('20'&(MID( POLICY_NO,5,2))))]<'2015','RENEWAL',IF([Year(MakeDate('20'&(MID( POLICY_NO,5,2))))]='2017','NEW',IF((Num(CR_MONTH)+365)-Num(RISK_MONTH)>365,'RENEWAL','NEW')))='RENEWAL',SUM(PREMIUM)*-1)

, CLASS_CODE, CR_MONTH, POLICY_NO, REASON, RISK_MONTH))

=Sum(Aggr(

, CLASS_CODE, CR_MONTH, POLICY_NO, REASON, RISK_MONTH))

Re: Subtotal wont come for calculated dimension

nevilledhamsiri — Sat, 19 Aug 2017 16:09:52 GMT

Issue solved!

Thanks Sunny,

That worked well. Thanks once again.

Neville

Re: Subtotal wont come for calculated dimension

sunny_talwar — Sat, 19 Aug 2017 19:49:51 GMT

Great, please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny