topic Re: Previous month data in QlikView

Previous month data

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

Hi all,

I have data with 3years so I need below. output attaching the sample data.

if I select any year with month from list box in the report title has to show like that "sales data &"selected month previous month" &"selcected year"

and one thing if I selsct januaary 2016 it has to show december 2015.

Re: Previous month data

migueldelval — Fri, 11 Nov 2016 09:15:31 GMT

Hi Sony,

Check please attach file and tell me if it´s ok.

Regards

Miguel del Valle

Re: Previous month data

varshavig12 — Fri, 11 Nov 2016 09:18:17 GMT

Addmonths()

Re: Previous month data

soniasweety — Fri, 11 Nov 2016 09:32:28 GMT

yes. its ok but I need other chart if I select year and month

it will display previous month data.

example: if I select feb 2016

I need to get chart as jan2016

Re: Previous month data

migueldelval — Fri, 11 Nov 2016 09:56:23 GMT

Hi Sony,

was ok my answer?

Have you got another Question?

Regards

Miguel del Valle

Re: Previous month data

susovan — Fri, 11 Nov 2016 10:06:58 GMT

Hi Sony,

You can also try this attachment,

Re: Previous month data

soniasweety — Fri, 11 Nov 2016 10:20:41 GMT

my reply showing as moderating your reply

Re: Previous month data

deepakkrish — Fri, 11 Nov 2016 10:38:13 GMT

can anyone elaborate, what logic is behind there?

because i am using personal edition only.

Thanks

Deepak.

Re: Previous month data

oknotsen — Fri, 11 Nov 2016 10:40:59 GMT

Which means you do not have enough points scored yet and a moderator has to approve your post after it checks if it is in the right area, not SPAM and without content we don't like to see here (like illegal content, cursing, etc).

I just approved almost all posts in queue, so your post is now visible.

Re: Previous month data

soniasweety — Fri, 11 Nov 2016 11:42:16 GMT

Hi Miguel del Valle

yes. its ok but I need other chart if I select year and month

it will display previous month data.

example: if I select feb 2016

I need to get chart as jan2016