topic Re: Maximum date sales in App Development

Maximum date sales

kkkumar82 — Mon, 21 Feb 2022 08:08:56 GMT

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

Re: Maximum date sales

EliGohar — Mon, 21 Feb 2022 09:16:20 GMT

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.

Re: Maximum date sales

anat — Mon, 21 Feb 2022 09:29:04 GMT

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.

Re: Maximum date sales

kkkumar82 — Mon, 21 Feb 2022 11:39:27 GMT

This link has some useful logics, thanks for sharing