[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,

[rendiyan]

i've awared that if i use no calculated dimension, it will work just fine.

But the requirement makes me have to split my chart.

And that's when my sum total doesn't show up.

[rendiyan]

works like charm.

But there's one curiousity.

In your expression, my formula is multiply to yours : Avg({<[Lv 1] = {'OPERATING EXPENSES'}>}1)

and what's that for?

Thank You

[sunny_talwar · Accepted solution]

If I remove that, you will see two rows

You can use an if statement to do that same thing.

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

But I prefer using expressions without if statements and that's why multiply with that expression

[rendiyan]

nice explanation.

thank you a lot Sunny