topic Comparison using set expression in App Development

Comparison using set expression

viralkmehta1968 — Sat, 11 Feb 2017 19:09:36 GMT

Hi,

I have a dropdown 'Bank Name' and a field for grouping of banks called 'Peer Group' (values are 'Assets < 100 million', 'Assets between 100 and 300 million' etc.). I also have a measure 'Net Income' by bank.

I want the user to select a bank from the dropdown and then show the 'Net Income' for the selected bank. Side-by-side, I also want to show the average net income for the 'Peer Group' that the selected bank belongs to. How can I do this? What will be the 'Set expression' to do this? See example below.

Selected Bank Peer Group

Net Income $11,985 $7,500

Thank you,

Re: Comparison using set expression

viralkmehta1968 — Sat, 11 Feb 2017 19:12:37 GMT

Please note that 'Peer Group' is an implicitly selected value. What will be the set expression to get the average net income for all banks in the peer group.

Re: Comparison using set expression

vinieme12 — Sun, 12 Feb 2017 12:35:03 GMT

please provide sample dataset that best replicates your scenario or a sample app

QlikCommunity Tip: How to get answers to your post?

Re: Comparison using set expression

vinieme12 — Sun, 12 Feb 2017 12:40:07 GMT

one way could be using e()

Expression for Selected Bank:

Sum(Revenue)

Expression for Other Banks in Peer Group

Sum({<BankName ,BankName = E(BankName) , PeerGroup = P(PeerGroup)>}Revenue)

Re: Comparison using set expression

vinieme12 — Sun, 12 Feb 2017 12:41:00 GMT

Re: Comparison using set expression

viralkmehta1968 — Mon, 13 Feb 2017 22:55:30 GMT

Thank you, Vineeth.

The set expression using E() and P() worked for me.

Re: Comparison using set expression

vinieme12 — Tue, 14 Feb 2017 03:37:29 GMT

Glad to help,

Can you mark a response as correct and close the thread please

Re: Comparison using set expression

viralkmehta1968 — Tue, 14 Feb 2017 14:28:48 GMT

I see an option 'Mark as Helpful' under 'Actions' but do not see an option to mark the answer as 'Correct'.

Re: Comparison using set expression

vinieme12 — Tue, 14 Feb 2017 18:33:16 GMT

There shud be a big Green button

Qlik Community Tip: Marking Replies as Correct or Helpful