Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Duky
Contributor
Contributor

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 :

State (based on starting digit) Suburb counts
4 2
2 2
3 1
Labels (3)
0 Replies