Expression Help

qv11user — Wed, 03 Mar 2021 14:11:39 GMT

Hi Team,

Hope everyone is doing good!

I have a requirement where i have a stacked bar chart with Month(on X-Axis) and Level as another dimension.
Data will be like below

Month       Level   Amount
Jan-2021    L1      1000
Jan-2021    L2      1100
Jan-2021    L3      1200
Feb-2021    L1      2000
Feb-2021    L2      2100
Feb-2021    L3      2200

I have to create two expressions, First is: Sum(Amount) as 'Bar' and another one is 'Text as Popup'
For the second expression I need to calculate amount based on Month(irrespective of level)
Ex: For Jan-2021 value is 3300,For Feb-2021 value is 6300
When i move cursor on bar i have to show amount values Sum(Amount) based on Month,Level and Month wise sum(Amount)(irrespective of Level).
I tried with Aggr function it didn't work.

Can you guys please help me to achieve this requirement.

Regards,
QV11 User

Re: Expression Help

Or — Wed, 03 Mar 2021 14:51:12 GMT

Sounds like a job for Sum(Total <Month> Amount)!

topic Expression Help in QlikView

Expression Help

Re: Expression Help