Get count by filtering with date and top 10 values
Hi, I m new to qlikview Could you please help me to write expression to get counts by filtering for a given date range and for top values.
First I need to get top 5 suburbs/postcode with the count of letters for a given date range (start and end date can be given)
I get this after writing the expression
=count( DISTINCT if ( postdate >= vStart and postdate <= vEnd , Letter) )
Postcode
Number of letters
4001
12
2001
10
4003
5
2022
2
3001
1
Then I need to get the number of suburbs in top 5 list in each state (State is identified by the first digit in the post code) I should get this as the output. How to get the Number of letters as follows :
