Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
Try this
=COUNT({<AccessibleMonth = {"=$(=Month(Today()))"}, [Reason for no access]={'Okay'}>} DISTINCT RelationshipCode)