Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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

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

View solution in original post

5 Replies
tresesco
MVP
MVP

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

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

MK_QSL
MVP
MVP

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

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

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Smitha,

Try this

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

Not applicable
Author

hi,

Thanks for the solution.

Regards,S

Smitha


Not applicable
Author

Thanks for the solution.

Thanks and Regards,

Smitha