topic Re: Only previous month's data in a bar chart? in QlikView

Only previous month's data in a bar chart?

divya_anand — Wed, 06 Jul 2016 15:05:27 GMT

Hi all, I hope someone out there can help me with this.

I have 3 fields- Month, region, sales.

I want to see a bar chart with only the previous month's sales with the Region on x-axis.

For ex, if the data I have is this:

Month	Region	Sales
mar	north	78518751
june	north	28632982
june	west	2378638
june	central	2369386
july	south	8136328
june	south	3863893

Now I want to see a bar chart which shows values (north, west, central, south) on x-axis (Since June is the previous month) with respective values on the bars.

Thank you.

Re: Only previous month's data in a bar chart?

sunny_talwar — Wed, 06 Jul 2016 15:38:56 GMT

If Month is a dual field, you can try this:

Sum({<Month = {"$(=MaxString(Month, 2))"}>} Sales)

Alternatively, I prefer using a date field over a month field. Do you have a date field in your application?

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

Re: Only previous month's data in a bar chart?

vinieme12 — Wed, 06 Jul 2016 15:44:28 GMT

Hi Divya,

Attaching two possibilities for your query. please see attached QVW.

Re: Only previous month's data in a bar chart?

divya_anand — Thu, 07 Jul 2016 05:40:03 GMT

This works. Just that I had to apply the condition on the dimension rather than the expression. Thank you.

Re: Only previous month's data in a bar chart?

vinieme12 — Thu, 07 Jul 2016 07:49:37 GMT

Glad to help

Cheers