topic Re: Current Month, Previous Month ,Current Month Previous Year in QlikView

Current Month, Previous Month ,Current Month Previous Year

scotly-victor — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have requirement that I want to show line chart that should be Current Month, Previous Month ,Current Month Previous Year wise sales

dimension: day

current month:

sum({<type={'Order'},FiscalMonth={$(=month(max(FiscalMonth)))}>} Sales)

it works fine

ex - FiscalMonth :apr

and i have encountered error in previous month

previous month:

sum({<type={'Order'},FiscalMonth={$(=month(max(FiscalMonth)-1))}>} Sales)

Can anybody help ?

Re: Current Month, Previous Month ,Current Month Previous Year

Anonymous — Tue, 03 May 2016 06:50:29 GMT

Hello Scotly

Please try using addmonths function as below:

addmonth(max(FiscalMonth),-1)

Regards

Chintan

Re: Current Month, Previous Month ,Current Month Previous Year

sunny_talwar — Tue, 03 May 2016 08:20:35 GMT

May be use this:

Previous Month

Sum({<type={'Order'}, Date = {"$(='<=' & Date(MonthStart(Max(Date), -1), 'YourDateFieldFormatHere') & '>=' & Date(MonthEnd(Max(Date), -1), 'YourDateFieldFormatHere'))"}>} Sales)

PreviousYear

Sum({<type={'Order'}, Date = {"$(='<=' & Date(AddYears(Max(Date), -1), 'YourDateFieldFormatHere') & '>=' & Date(AddYears(Max(Date), -1), 'YourDateFieldFormatHere'))"}>} Sales)

If this doesn't work, would you be able to provide a sample to look at?

Re: Current Month, Previous Month ,Current Month Previous Year

Anil_Babu_Samineni — Tue, 03 May 2016 08:30:00 GMT

Sunny,

I hope all is well with QlikView..

I have one Excel, In that.. In that i have fields like -- Date, Sales, Product..

So, once i apply to Bar graph. I want to achieve in bar chart show current month, previous month, last year current month.

Ex:- Let's Say, if i select May - 2016 on dimension i want in bar chart like -- May - 2016 and April - 2016 and May - 2015

Note: Please find O/P like attached Image for Reference..!

Thanks,

Anil.

Re: Current Month, Previous Month ,Current Month Previous Year

Anonymous — Wed, 04 May 2016 04:42:53 GMT

Hello Scotly

Are you able to resolve your issue? You may post the expression you used, it will be useful for others facing similar issue.

Thanks & Regards

Chintan

Re: Current Month, Previous Month ,Current Month Previous Year

scotly-victor — Wed, 04 May 2016 05:26:32 GMT

Hi Chinatan,

Issue got resolved.

Thank you

Re: Current Month, Previous Month ,Current Month Previous Year

stephenedberkg — Wed, 04 May 2016 05:34:01 GMT

try this

sum({<type={'Order'},FiscalMonth={$(=month(max(FiscalMonth)-1))},month=,year=>} Sales)

Re: Current Month, Previous Month ,Current Month Previous Year

Anil_Babu_Samineni — Wed, 04 May 2016 06:12:16 GMT

Can you please post that. If possible, Please stick the Correct answer whoever gave the right way on your wall tab. Current Month -- Expression ? Last Month -- Expression ? Last Year Current Month -- Expression ?