Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
francois_974
Contributor III
Contributor III

Calculate delay et average in set analysis

Hello

i have a question that i can't resolve by myself  after time... thanks for helping

I have a table of command & delivrey like this : extract for one "code-fournisseur"

francois_974_0-1613532465202.png

I would like a table group by code fournisseur like This

Code-founisseurMax delaiMin delaiAverageMedian
510 - PROMONET PROMED337210724

 

I try many solution but it doesent work  . 

Can you please help me for this ?

Thanks a lot 

 

Labels (1)
2 Replies
MayilVahanan

HI @francois_974 

Try like below

Max: Max(Aggr(Urexpression, Code-founisseur))

Min: Min(Aggr(Urexpression, Code-founisseur))

Avg(Aggr(Urexpression, Code-founisseur))

Median(Aggr(Urexpression, Code-founisseur))

Can you say u expression or sample data?

Thanks & Regards,
Mayil Vahanan R
francois_974
Contributor III
Contributor III
Author

Hello @MayilVahanan 

Thank you  . i don't understand how to do that. 

In my tableau(picture)

the calculate field "max delai" is based on 'No cde (ec)' and "Max(dateRecep)-DateCommande"

When i try to apply it like your proposal : 

Max(Aggr(Max(dateRecep)-DateCommande, Code-founisseur))

it don't works, and i try this to:

Max(Aggr(Max(DateRecep)-DateCommande,[Nb lig Cde (lc)],[Code - fournisseurs(fr)]))

it dont works anymore?

i don't understand what you mean : "Can you say u expression or sample data?"

Thank you to take time for my case