Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
please provide sample dataset that best replicates your scenario or a sample app
QlikCommunity Tip: How to get answers to your post?
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)
read more about P() and E() here
https://community.qlik.com/thread/68931
Thank you, Vineeth.
The set expression using E() and P() worked for me.
Glad to help,
Can you mark a response as correct and close the thread please
I see an option 'Mark as Helpful' under 'Actions' but do not see an option to mark the answer as 'Correct'.
There shud be a big Green button
Qlik Community Tip: Marking Replies as Correct or Helpful