Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
please kindly help on the expression to show current month volume.
please correct my below expression
I want to count the shipment volume for current month.
COUNT({$<[ETD.autoCalendar.Month] = "{(month(today()))}">} [OTM Shipment ID])
Please help. I tried many ways to do it but either '-' or '0"
Thank you for much.
May be this
Count({$<[ETD.autoCalendar.Month] = {"$(=Month(Today()))"}>} [OTM Shipment ID])
You could try setting the current month via a variable and referring to that instead.
To ensure you will get only current month's value, maybe this could be helpful:
Count ({<[ETD.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}[OTM Shipment ID])
Cheers
Hi Sunny, thank you so much for your answer. it works. may I know can I count the volume for last month as below.
Count({$<[ETD.autoCalendar.Month] = {"$((=Month(Today()))-1)"}>} [OTM Shipment ID])
Hi Thiago Teixeira,
Yes ! it works as well. but can I have one more question followed by this?
how to get last month value with this expression?
May be this
Count({$<[ETD.autoCalendar.Month] = {"$(=Month(AddMonths(Today()-1)))"}>} [OTM Shipment ID])
Dear Rachel Delany,
it's a great idea. but I'm beginner for qlik sense. actually I would like to find out the difference between this month and next month volume.
do you have any idea on this ?
Thank you for your quick response.
but the result is "0".
You could try this:
Count ({<[ETD.autoCalendar.Date]={">=$(=AddMonths(MonthStart (Today ()),-1))<=$(=AddMonths(MonthEnd (Today ()),-1))"}>}[OTM Shipment ID])