Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Patman
Contributor III
Contributor III

Count Column A if Column B >0

Please advise,

                               I have tried this and it appears to be just counting A

Count({<Primary={"*"}>}Primary and Q1>0)

2 Solutions

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Like this:

Count({<Q1 = {">0"}>} Primary)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Patman
Contributor III
Contributor III
Author

Many thanks, much appreciated.

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Like this:

Count({<Q1 = {">0"}>} Primary)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Patman
Contributor III
Contributor III
Author

Many thanks, much appreciated.