topic Re: Display previous month data in QlikView

Display previous month data

aleksas_baltpool — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'd like to have a column that shows data from a previous month. Tried doing this with set analysis however with no luck.

Script regarding this table looks like that:

I'm using hau_month as a dimension in the chart. I'd like to display sum(hau_total_amount) for the current and for the previous month.

Tried something like that: sum({<hau_month={$(=Max(hau_month)-1)}>}hau_total_amount)

However the result is zeroes. Hope you can help me with it !

Re: Display previous month data

basav — Wed, 15 Jul 2020 15:49:59 GMT

Hi,

What type of chart you are trying to create.

Did you try bar chart, with month(hau_month) in the dimension, and sum(hau_total_amount) as expression. This should show month wise data.

It would be better if you upload a sample QVW or screenshots along, this will help us give you correct answer.

cheers,

Basav

Re: Display previous month data

aleksas_baltpool — Thu, 16 Jul 2020 05:04:09 GMT

Hi, I'm creating a table chart. There is no problem displaying data month wise, however in this case I need to display previous period (month) data in the same column. What would you like to see in the screenshot?

Re: Display previous month data

basav — Thu, 16 Jul 2020 05:13:55 GMT

Hi,

Please always try to attach sample QVW with sample data, if a precise answer is required.

Please check these posts, hope these helps:

https://community.qlik.com/t5/New-to-QlikView/Show-previous-month-data/td-p/1246957

https://community.qlik.com/t5/QlikView-App-Development/How-to-show-previous-month-data-in-current-month/td-p/1275409

cheers,

Basav

Re: Display previous month data

aleksas_baltpool — Thu, 16 Jul 2020 05:35:37 GMT

I've already checked those topics before posting but didn't manage to adapt formulas to my document.

I've uploaded sample file.

Re: Display previous month data

tresB — Thu, 16 Jul 2020 06:02:38 GMT

Try this expression:

=sum(TOTAL {<MonthYear={'$(vPrevMthNo)'}>}[Total Stock])

Re: Display previous month data

aleksas_baltpool — Thu, 16 Jul 2020 06:19:49 GMT

Would it be possible for you to edit this expression according to the sample file I've uploaded? That would be a big help!

Re: Display previous month data

tresB — Thu, 16 Jul 2020 06:27:51 GMT

Sorry, I didn't get you. I have already edited your expression , i.e. - added 'total' in the expression.

Re: Display previous month data

aleksas_baltpool — Thu, 16 Jul 2020 07:03:20 GMT

Oh sorry wrong file uploaded...

This is correct one:

Re: Display previous month data

tresB — Thu, 16 Jul 2020 08:06:48 GMT

When you use month as dimension, try like:

Above(sum(hau_total_amount))

Re: Display previous month data

aleksas_baltpool — Thu, 16 Jul 2020 08:58:34 GMT

Is it possible to get data from two months ago using some kind of formula like that?

Re: Display previous month data

tresB — Thu, 16 Jul 2020 10:49:07 GMT

Above(sum(hau_total_amount), 2)

Re: Display previous month data

aleksas_baltpool — Thu, 16 Jul 2020 10:56:17 GMT

Great, thanks!