Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am currently working on a qlikview expression that is quite intricate. It involves loans and calculating bank exposure - so I am adding many different fields together using set analysis. Even though I am using different fields and different set analysis expressions I would like to eliminate all closed and charged off loans for the entire expression. Is it possible to enclose all of my separate set analysis expressions with a set analysis expression that excludes the loans that are closed and charged off?
Thank you.
It's possible to nest set analysis expressions. If you nest aggregation functions don't forget to use the aggr function. I cannot say what will work in your specific situation. If you need help with that you'll have to post more information, preferably a qvw document with representative data.
It's possible to nest set analysis expressions. If you nest aggregation functions don't forget to use the aggr function. I cannot say what will work in your specific situation. If you need help with that you'll have to post more information, preferably a qvw document with representative data.