Get count by filtering with date and top 10 values

Duky — Fri, 16 Dec 2022 02:04:02 GMT

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

topic Get count by filtering with date and top 10 values in QlikView

Get count by filtering with date and top 10 values