Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
paul_ripley
Contributor III

How to exclude

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

1 Solution

Accepted Solutions

Re: How to exclude

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)

View solution in original post

4 Replies

Re: How to exclude

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)

View solution in original post

manucamon
Valued Contributor III

Re: How to exclude

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 )


OR

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 )

paul_ripley
Contributor III

Re: How to exclude

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

paul_ripley
Contributor III

Re: How to exclude

Thanks for your help