Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
anil_y_86
Contributor III
Contributor III
‎2016-07-26 07:40 AM

Hi, Can someone help me for the logic

Hi Community Experts,  Need Quick help on this

Our company Financial year cycle starts from Oct to September. 

I have fields/columns from Oct to June as

MthData11 for Oct ,

MthData10 for Nov,

MthData9 for Dec and so on till

..

...

..

MthData for Sep. 

For July, Aug and Sep data is "0". 
Now I need to build a logic such that when I reload the dashboard every month MthData2 will be my current month (July) and MthDate3 (June) will be my previous month and MthDate4 (May) will be my Previous to Previous month.


(When I reload the dashboard in September MthData will be my currentmonth and MthData1 is Previous and MthData2 is PrevtoPrev)


Please help me to build the logic ?


Thanks in Advance

426 Views
0 Likes
2 Replies
anil_y_86
Contributor III
Contributor III
‎2016-07-26 08:26 AM
Author

Any respone please

345 Views
0 Likes
marcus_sommer
MVP
MVP
‎2016-07-26 08:39 AM

I think you need to work with a fiscal calendar maybe connected with a normal master-calendar. Here you will find many informations and examples: How to use - Master-Calendar and Date-Values.

- Marcus

345 Views
0 Likes