Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
soniasweety
Valued Contributor III

Previous month data

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.
9 Replies
migueldelval
Valued Contributor

Re: Previous month data

Hi Sony,

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

Regards

Miguel del Valle

varshavig12
Valued Contributor

Re: Previous month data

Addmonths()

soniasweety
Valued Contributor III

Re: Previous month data

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

migueldelval
Valued Contributor

Re: Previous month data

Hi Sony,

was ok my answer?

Have you got another Question?

Regards

Miguel del Valle

Partner
Partner

Re: Previous month data

Hi Sony,

You can also try this attachment,

soniasweety
Valued Contributor III

Re: Previous month data

my reply showing as moderating your reply

deepakkrish
New Contributor III

Re: Previous month data

can anyone elaborate, what logic is behind there? 

because i am using personal edition only.

Thanks

Deepak.

oknotsen
Honored Contributor III

Re: Previous month data

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.

May you live in interesting times!
soniasweety
Valued Contributor III

Re: Previous month data

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