topic Re: How to exclude in QlikView

How to exclude

paul_ripley — Fri, 17 Jun 2016 09:55:06 GMT

Hello

Within our financial system account codes ("groupcoa") are grouped into similar categories called "pl"

Within my set analysis in QV I would like to include some account codes from a pl but not others

The current set analysis is shown below

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa -= {'6990'}, pl = {"A01","B01","F02","F03","F04","G01","F06","L01","O01","J05"
}>} IS_Investment_GBP )

Within the "pl" grouping J05 which contains hundred of account code, I actually only want to include groupcoa 8950,7950,6950.

How can I restrict the pl grouping J05 to just these 3?

Many thanks

Paul

Re: How to exclude

sunny_talwar — Fri, 17 Jun 2016 10:27:51 GMT

May be this:

Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa -= {'6990'}, pl = {"A01","B01","F02","F03","F04","G01","F06","L01","O01"}>+

$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa = {8950, 7950, 6950}, pl = {"J05"}>} IS_Investment_GBP)

Re: How to exclude

Anonymous — Fri, 17 Jun 2016 10:28:50 GMT

Hi Paul:

Try this

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa -= {'6990','8950','7950','6950'}, pl = {"A01","B01","F02","F03","F04","G01","F06","L01","O01","J05" }>} IS_Investment_GBP )

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa -= {'6990'}, pl = {"A01","B01","F02","F03","F04","G01","F06","L01","O01","J05" }>} IS_Investment_GBP )

-sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, groupcoa = {'8950','7950','6950'}, pl = {"J05" }>} IS_Investment_GBP )

Re: How to exclude

paul_ripley — Fri, 17 Jun 2016 10:39:31 GMT

Thanks again Sunny. That's really helpful and it worked

Re: How to exclude

paul_ripley — Fri, 17 Jun 2016 10:40:32 GMT

Thanks for your help