Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
Specialist
Specialist

Hi Sony,

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

Regards

Miguel del Valle

varshavig12
Specialist
Specialist

Addmonths()

soniasweety
Master
Master
Author

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
Specialist
Specialist

Hi Sony,

was ok my answer?

Have you got another Question?

Regards

Miguel del Valle

susovan
Partner - Specialist
Partner - Specialist

Hi Sony,

You can also try this attachment,

Warm Regards,
Susovan
soniasweety
Master
Master
Author

my reply showing as moderating your reply

deepakkrish
Creator
Creator

can anyone elaborate, what logic is behind there? 

because i am using personal edition only.

Thanks

Deepak.

oknotsen
Master III
Master III

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
Master
Master
Author

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