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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Shahzad_Ahsan
Creator III
Creator III

Sum of Max values with different dimension

Hi

I have data like this:

CategoryValueREADING_DATE
A193.759994501-Nov-2019 
B782.489990201-Nov-2019 
A193.389999401-Nov-2019 
B782.479980501-Nov-2019 
B782.429992701-Nov-2019 
A192.899993901-Nov-2019 
B782.429992701-Nov-2019
B782.380004901-Nov-2019 
B782.380004901-Nov-2019 

 

I need to create expression which gives Sum of Max Value with different category

Expected Result:

ValueREADING_DATE
976.2401-Nov-2019
Labels (1)
2 Replies
Lisa_P
Employee
Employee

aggr.PNG

 

 

Shahzad_Ahsan
Creator III
Creator III
Author

Hi Lisa

Thanks for your reply.

I have used this, this is working fine for test but not on my live Data.

I have attached my QVF please have a look.

In Line chart there is drill down By month , date and Time. 

I need the Sum of Max values with different categories.