SUM action on a Qlikview Button.

[Vijesh]

Hello,

I am very new to QlikView. 

Can we create a button to get substract two sum values mentioned in attachment?

Thanks,

V.

[sunny_talwar]

When you say button are you looking for a KPI (Qlik Sense) or Text box (QlikView) to show 12?

[Vijesh]

Textbox or table in QlikView. 

[Gabriel]

Hi,

I don't think you need a button or textbox for that. There are other ways of achieving what you mention.

For what you shared in your attachment I would suggest simple use of SUM function and such as below

SUM({<Type ={PIV}>}Value) - SUM({<Type ={SRT}>}Value).

And if you're using the expression in multiple places in your analysis then turn the aggregation into variable

Hope this helps

[Vijesh]

Can you help me with a sample QVW file?

[Gabriel · Accepted solution]

See attached as requested.

[Vijesh]

Great. cracked it. Thanks a lot.

[Vijesh]

Hello Friend,

Can you help me on this attached excel file. I have mentioned what output I want.

Still in a learning stage, I tried but failed... 🙂

[Gabriel]

Hi,

I think it's best you open new question?

[Vijesh]

OK