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: 
dieter13
Contributor II
Contributor II

Maximum value of all data

Hello,

  

Max(Aggr(SUM({<STOFF_KZ={'L'}>}SALES)/SUM(SALES), COMPANY,MONTH

))

I have this expression which returns the maximum quota of leather sales per month and company for my current selected period.

Now I want to have the maximum quota for the whole period although I have selected only one month.

How can I solve this problem?

This expression e.g. returns the maximum date of all dates although I have selected only one month.

 

Max({$<MONTH>}DATE

)

How can I combine this two expressions?

Thanks for your help. 

Dieter

2 Replies
nizamsha
Specialist II
Specialist II

Max(Aggr(SUM({$<STOFF_KZ={'L'}>}SALES)/SUM(SALES), COMPANY,MONTH

))

use current selection it will display  year and month what  u selected

aggr(sum({$<year={"$(=Max(Year))"},month={"$(=max(Month))"},stock={"L"}>}sales)/sum({$<year={"$(=Max(Year))"},month={"$(=max(Month))"}Sales),company,month)

Gysbert_Wassenaar

Try: Max(total Aggr(SUM({<STOFF_KZ={'L'}>}SALES)/SUM(SALES), COMPANY,MONTH))

or perhaps Max({1} total Aggr(SUM({<STOFF_KZ={'L'}>}SALES)/SUM(SALES), COMPANY,MONTH))


talk is cheap, supply exceeds demand