Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankit1988
Contributor III
Contributor III

Expression

how to write expression in QlikView to get 'Pan India' or Zone , State and OEM wise total count of Relationship Code where Accessible Month equals with the month for which the report is getting prepared and 'Reason for no access' = 'Okay'

 

Labels (1)
1 Reply
Chanty4u
MVP
MVP

Try this 

=COUNT({<AccessibleMonth = {"=$(=Month(Today()))"}, [Reason for no access]={'Okay'}>} DISTINCT RelationshipCode)