Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijesh
Contributor
Contributor

SUM action on a Qlikview Button.

Hello,

I am very new to QlikView. 

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

 

Thanks,

V.

1 Solution

Accepted Solutions
Gabriel
Partner - Specialist III
Partner - Specialist III

See attached as requested.

View solution in original post

10 Replies
sunny_talwar

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

Textbox or table in QlikView. 

Gabriel
Partner - Specialist III
Partner - Specialist III

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
Contributor
Contributor
Author

Can you help me with a sample QVW file?

Gabriel
Partner - Specialist III
Partner - Specialist III

See attached as requested.

Vijesh
Contributor
Contributor
Author

Great. cracked it. Thanks a lot.

Vijesh
Contributor
Contributor
Author

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
Partner - Specialist III
Partner - Specialist III

Hi,

I think it's best you open new question?

Vijesh
Contributor
Contributor
Author

OK