Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to Qlik and I've been tasked with something that is above my beginner status. Below is a screen that has been filtered by "Owner" (Filter Box #1). What I need is to have Chart #2 NOT filter but display totals for all the Owners. The intent is to create a "challenge" showing each Owner where they stand against the others.
Any help is appreciated.
Try expression like:
Sum({<OWNER>} Amount)
It could be any other aggregation function in place of sum(). This is called Set Analysis, learn about it from help.
Try expression like:
Sum({<OWNER>} Amount)
It could be any other aggregation function in place of sum(). This is called Set Analysis, learn about it from help.
Thank you so much. That works perfectly.
I've used Set Analysis in other instances but I had a mental block on this one. Thanks again.