[ASK] sum total not show

[rendiyan]

Dear Qlik Master,

I have a req that need to split dimension into 2 chart using calculated dimension, and have to calculate actual value of 1 dimension to compare to another dimension.

simulation like below :

My calculated condition for above screenshot is :

if([Group Lv1]='REVENUES' or [Group Lv1]='COST OF REVENUES',[Group Lv1])

And my actual rev expression is :

Sum(TOTAL<YEAR>

{<

  YEAR={'$(=$(vMaxYear))'},

  [PL Group Lv1]={'REVENUES'}

>}

MOVEMENT_BALANCE)

For above screenshot there is no issue, but when i create my second chart with different definition of dimension, my actual rev doesn't show up.

Screenshot is below :

my calculated dimension condition for above (second screenshot) is :

if([Group Lv1]='OPERATING EXPENSES',[Group Lv1])

For my both chart, i use suppress when value is null.

But my actual rev doesn't show up in my second chart.

Is there any solution?

Thank You,

Best Regards,

[shraddha_g]

what expression you have used for 2nd chart

[sunny_talwar]

Would you be able to share a sample to test this out?

[stabben23]

Change calculation to this maybe.

Sum(TOTAL<YEAR>

{<

  YEAR={'$(=$(vMaxYear))'},

  [PL Group Lv1]={'OPERATING EXPENSES'}

>}

MOVEMENT_BALANCE)

[rendiyan]

Dear Shraddha,

My expression for second chart is the same as my first one.

Sum(TOTAL<YEAR>

{<

  YEAR={'$(=$(vMaxYear))'},

  [PL Group Lv1]={'REVENUES'}

>}

MOVEMENT_BALANCE)

[rendiyan]

Hi Staffan,

The objection why i show Actual Rev is to calculate every actual of each group to actual of revenue.

So the general formula is :

[Actual of each Group] / [Actual of Group Revenue]

Thank You

[rendiyan]

Hi Sunny,

PFA.

Thank You

[stabben23]

sum({<[Group Lv1]={'OPERATING EXPENSES'}>}MOVEMENT_BALANCE)/Sum(TOTAL<YEAR> < YEAR={'$(=$(vMaxYear))'}, [PL Group Lv1]={'REVENUES'},  >}  MOVEMENT_BALANCE)

And no calculated Dimension, just  [PL Group Lv1]

[Anonymous]

Try

sum({1<YEAR= {'2016'},[PL Group Lv1]={'REVENUES'}} MOVEMENT_BALANCE)

with hardcoded Year then substitute with variable.

[sunny_talwar]

Try this

Dimension

Lv 1

Expression

Sum({<[Lv 1] = {'OPERATING EXPENSES'}>}Actual)

Sum(TOTAL<YEAR>{<YEAR={'2016'}, [Lv 1]={'REVENUES'}>}Actual) * Avg({<[Lv 1] = {'OPERATING EXPENSES'}>}1)