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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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)