Hi ,
I am new in qliksense,
Please help to resolve the below scenario for YTD, MTD, QTD in Qlik sense/QlikView.
Scenario:
We have data for last 3 year, Year start from Oct to Sep, For example Oct 2016 to Sep 2017 is our FY1, Oct 2017 to Sep 2018 FY2
we have 3 Button two show the YTD, MTD, and QTD
Case1: By Default QTD is selected which is showing the FiscalMonth=Jun( Current Month)
result for the Sales will Be Sum( Sales) for Q3 not only for Jun, Suppose user select Feb then result will be Sum (Sales) for Jan & Feb only, march not included
Case2: When User selected YTD, in that Case result will be Sum( Sales) For Q1 to Q3( Because Jun is selected)
For 2nd example result will be Sum(sales) for Oct to March
Case3:- When User select MTD , result will be sum(Sales) for Jun or based on the selection March & Jun Selected then Result will be Sum(Sales) for Jun & March
|
8/1/2017 | 5 | a |
9/1/2017 | 6 | b |
10/1/2017 | 10 | a |
11/1/2017 | 2 | a |
1/1/2018 | 4 | b |
1/1/2018 | 5 | a |
2/1/2018 | 1 | a |
3/1/2018 | 6 | b |
12/1/2017 | 10 | b |
3/1/2018 | 12 | a |