Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
PeterHa
Contributor
Contributor
‎2021-11-09 09:22 AM

How to count the contracts with multiple date.

I want to make a bar chart, in which we can see the number of contracts. But the vehicle order of the contract needs to be the first vehicle order by date and its needs to be the a "Main" order.

I have ben looking all over this place and searching the net but just can't get it right.

=Aggr(count(DISTINCT if(VoertuigorderType='xx' and VoertuigorderExterneStatus <>'xx' And Leasemaatschappij<>'xx' and Leasemaatschappij<>'xx' and ProductBeschrijving<>'xx', ContractReferentie))min(VoertuigorderBestelDatum),ContractReferentie))

who can help me out with the measurement?

 

 

480 Views
0 Likes
1 Reply
vinieme12
Champion III
Champion III
‎2021-11-14 04:58 AM

please post some sample data and expected output

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
419 Views
0 Likes