Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

right syntaxe

hello ;   i m looking for the right syntaxe , i have  a code_client , he has a date for his creation (creation_client) and a date of the first cost estimate (date_devis) for the product, however a client can exist more then one time  with more then onedate_devis,

i want in my chart the  interval (date_devis-creation_client)  for the client but just the first cost estimate ...please help



Capture.PNG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try in a chart with dimension CODE_CLIENT an expression

=interval (Min(DATE_DEVIS) - Min(DATE_CREATION) )

View solution in original post

1 Reply
swuehl
MVP
MVP

Try in a chart with dimension CODE_CLIENT an expression

=interval (Min(DATE_DEVIS) - Min(DATE_CREATION) )