0 Replies Latest reply: Sep 13, 2018 2:29 PM by prem acharya RSS

    Creating comparative report in Qlik Sense

    prem acharya

      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 :

         

      PerioddateAccountProductAmount
      30/09/18Account_1PR_A100
      30/09/18Account_2PR_B200
      30/09/18Account_3PR_C150
      31/08/18Account_1PR_A110
      31/08/18Account_2PR_B210
      31/08/18Account_3PR_C160
      30//07/18Account_1PR_A120
      30//07/18Account_2PR_B220
      30//07/18Account_3PR_C170

       

       

      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)
      Date130/07/18
      Date230/09/18

       

      Result Table :

       

          

      Date1Date2
      AccountProductAmountAmountChange%change
      Account_1PR_A1001202020.00%
      Account_2PR_B2002202010.00%
      Account_3PR_C1501702013.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 ?