Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Gopi_E
Creator II
Creator II

Calculate current month and previous month sales

Hi Qlikers,

@sunny_talwar 

Here I have data like this 

Month_Table:
LOAD * INLINE [
Month_Name, Sales,
Jan, 10
Feb, 20
Mar, 30
Apr, 40
May, 50
Jun, 60
Jul, 70
Aug, 80
Sep, 90
Oct, 100
Nov, 110,
Dec, 120
];

From this table, I need to calculate the current month and previous month sales, please give how to calculate sales using this type of data

Thanks in advance

1 Solution

Accepted Solutions
Gopi_E
Creator II
Creator II
Author

Thank you for the reply,

yes I want this based on the current selection

I did this by creating a table with month name and month number and this table I was joined to the original table.

is there any other way please suggest.

Thanks in advance.

View solution in original post

4 Replies
Gopi_E
Creator II
Creator II
Author

@sunny_talwar  

Hi sunny can you look on to this 

Thanks in advance

sunny_talwar

You want this based on selection or current month will always be Today's month and previous month will be the last month from today. Meaning September will be current month and August will be previous month until we reach October?

Gopi_E
Creator II
Creator II
Author

Thank you for the reply,

yes I want this based on the current selection

I did this by creating a table with month name and month number and this table I was joined to the original table.

is there any other way please suggest.

Thanks in advance.

View solution in original post

sunny_talwar

I am still not 100% sure what you are looking to do... but if you can share what you have applied, I might be able to see what you did and let you know if there are other options you can try