Discussion Board for collaboration related to QlikView App Development.
Here I have data like this
Month_Table:LOAD * INLINE [Month_Name, Sales,Jan, 10Feb, 20Mar, 30Apr, 40May, 50Jun, 60Jul, 70Aug, 80Sep, 90Oct, 100Nov, 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
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
Hi sunny can you look on to this
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?
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