topic Re: SUM action on a Qlikview Button. in QlikView

SUM action on a Qlikview Button.

Vijesh — Mon, 03 Dec 2018 13:53:20 GMT

Hello,

I am very new to QlikView.

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

Thanks,

sunny_talwar — Mon, 03 Dec 2018 14:12:26 GMT

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

Vijesh — Tue, 04 Dec 2018 05:23:04 GMT

Textbox or table in QlikView.

Gabriel — Thu, 06 Dec 2018 13:23:10 GMT

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 — Thu, 06 Dec 2018 13:58:15 GMT

Can you help me with a sample QVW file?

Gabriel — Thu, 06 Dec 2018 14:25:22 GMT

See attached as requested.

Vijesh — Sat, 08 Dec 2018 11:51:45 GMT

Great. cracked it. Thanks a lot.

Vijesh — Tue, 11 Dec 2018 13:38:38 GMT

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 — Tue, 11 Dec 2018 13:40:07 GMT

Hi,

I think it's best you open new question?

Vijesh — Tue, 11 Dec 2018 13:41:05 GMT

Vijesh — Tue, 11 Dec 2018 13:47:13 GMT

Hello Friend,

I have opened a new question. please find the link.

Please help me.