Maximum date sales

[kkkumar82]

Hi Qlikers,

I have data like below table

Date	Sales
10/31/2021	150
11/30/2021	250
12/15/2021	125
12/31/2021	250
1/20/2022	200
1/31/2022	275
2/20/2022	300

I want to create a bar chart in MMM-YY format where I want to show the sales per month but in a month if we have two dates, the max should be taken, as the max date includes the sales of other dates too.

Need to achieve this in UI expressions only

[EliGohar]

Hi @kkkumar82 

If you wish to get this result:

Then just create the following Dimension in your Bar chart/table:

=Date(MonthStart(Date), 'MMM-YYYY')

And of course, use the Max(Sales) measure to find the maximum per month-year.

Hope it helped,

Eli.

[anat · Accepted solution]

https://community.qlik.com/t5/New-to-Qlik-Sense/pull-max-Date-from-each-month/td-p/1529729

can i try above link if u haven't gone.

[kkkumar82]

This link has some useful logics, thanks for sharing