Based on time period value will change

nisha_rai — Wed, 25 Nov 2020 16:16:04 GMT

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

Date(MM/DD/YYYY)	Sales	Item
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

topic Based on time period value will change in QlikView

Based on time period value will change