Creating comparative report in Qlik Sense

[acharya09]

Greetings Users ,

I am New to Qlik and wondering if something the below approach is feasible in QlikSense.

I have a table with period date as a row value , with multiple other dimension. Something like below :

Perioddate	Account	Product	Amount
30/09/18	Account_1	PR_A	100
30/09/18	Account_2	PR_B	200
30/09/18	Account_3	PR_C	150
31/08/18	Account_1	PR_A	110
31/08/18	Account_2	PR_B	210
31/08/18	Account_3	PR_C	160
30//07/18	Account_1	PR_A	120
30//07/18	Account_2	PR_B	220
30//07/18	Account_3	PR_C	170

My requirement is to have 2 dates fields as a filter option (something that can be achieved by a user defined field) . And use those date fields to calculate the change and change percentage

Filters(User Entered)
Date1	30/07/18
Date2	30/09/18

Result Table :

		Date1	Date2
Account	Product	Amount	Amount	Change	%change
Account_1	PR_A	100	120	20	20.00%
Account_2	PR_B	200	220	20	10.00%
Account_3	PR_C	150	170	20	13.33%

There is only singe date column in my table. This also brings the question if setting the filter as mandatory is possible in Qlik Sense and if we can limit the filter input to a single value.

Is there any alternative solution ?