7 Replies Latest reply: Jun 25, 2017 12:26 PM by Edgar Kim RSS

    something like a flag to determine daily formula => possible?

    Edgar Kim

      Hi,

      I am fairly new to Qlik Sense/Qlikview and with the help of books/google/youtube I was able to create my first apps sucessfully.

      However, maybe due to the lack of some basic conceptual understanding I can not solve this problem  - any ideas are higly appreciated :-)

       

      I would like to create a daily sales report with sales per day, per month, ytd, etc.  So far no problem thanks to set analysis.

      But if today is 29th of june I want to use a different formula than if today is the 30th of june because the 30th would be month-end closing. (month-end closing could be on last day of actual month, first day of new month or any day of new month).

       

      Is it possible to use a 'closingFlag' column in my excel data to create something like (i know this example makes no sense, only to give example):

       

      if todays date has closingFlag={1},

      sum({$<SDate={'>=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))'}>}Sales),

      sum({$<SDate={'>=$(=MonthStart(Today()))<=$(=Today())'}>}Sales)

       

      what is the correct syntax for smthg like this or is there a better way to solve this?

      the report will then be sent automatically with nprinting that is why i need some logic in my app to determine which formula should be used.

       

      Thank you in advance

      regards

      E.

       

       

      SDateSalesclosingFlag
      01.01.2017100
      xxyz
      31.05.20172001
      01.06.20175
      29.06.20178
      30.06.2017991
      01.07.201725
      31.07.201714
      01.08.201726
      02.08.2017881