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 :
State (based on starting digit) |
Suburb counts |
4 |
2 |
2 |
2 |
3 |
1 |