Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Display few divisions on whole set

Hi,

I have a requirement wherein I need to display few division sales from a set of division names.

As per the requirement, it should consider those division names which has the string 'SAP' and exclude one among that.

I tried as below,

=count({$<{"*SAP*"}-{'SAP Service'}>}Sales)

Can anyone please let me know if am on the right track. If not,please help me to achieve this requirement.

Thanks & Regards,

Smitha

1 Solution

Accepted Solutions
MVP
MVP

Re: Display few divisions on whole set

Right track with a minor correction needed. May be like this?

=count({$<YourField = {"*SAP*"}-{'SAP Service'}>}Sales)

5 Replies
MVP
MVP

Re: Display few divisions on whole set

Right track with a minor correction needed. May be like this?

=count({$<YourField = {"*SAP*"}-{'SAP Service'}>}Sales)

MVP
MVP

Re: Display few divisions on whole set

Count({$<[Division Name] = {"*SAP*"}-{'SAP Service'}>}Sales)

Use SUM instead of Count if you want to calculate Total Sales.

Partner
Partner

Re: Display few divisions on whole set

Hi Smitha,

Try this

=count({$<YourField={"*SAP*"},YourField-={'SAP Service'}>}Sales)

Not applicable

Re: Display few divisions on whole set

hi,

Thanks for the solution.

Regards,S

Smitha


Not applicable

Re: Display few divisions on whole set

Thanks for the solution.

Thanks and Regards,

Smitha