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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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)