3 Replies Latest reply: Dec 1, 2015 7:29 AM by Marko Tuta RSS

    Double quotes within double quotes in set analysis

      Hi,

      I have a problem with double quotes in double quotes within set analysis. I
      read two posts:

      double quote
      wrapper in double code issue in set analysis

      and

      QlikView Quoteology

       

      but none of them answer my question.

       

      I have the following code:

       

      =count({$<
      SALES_ID={"=SUM({<MY_DATE =
      {">=$(=Date(MakeDate(year(min(MY_DATE))-1,Month(min(MY_DATE)),Day(min(MY_DATE)))))<=$(=Date(MakeDate(year(max(MY_DATE))-1,Month(max(MY_DATE)),Day(max(MY_DATE)))))">}SALES_AMOUNT)>0"
      },

      MY_DATE = {">=$(=Date(MakeDate(year(min(MY_DATE))-1,Month(min(MY_DATE)),Day(min(MY_DATE)))))<=$(=Date(MakeDate(year(max(MY_DATE))-1,Month(max(MY_DATE)),Day(max(MY_DATE)))))"}

      >}
      DISTINCT SALES_ID)

       

       

      The user select a date interval MY_DATE. Then I take this interval and I
      define the same interval but FOR THE PREVIOUS YEAR (minus 1 year). For
      instance: the user select 1.1.2015 - 31.9.2015 --> MY_DATE = 1.1.2014 -
      31.9.2014. I want to count different products SALES_ID in this period of time.

       

      Additionally, I want also count only that SALES_ID which have some sales
      amount > 0 (it can happen that I have SALES_ID with SALES_AMOUNT=0 in the
      period 1.1.2014 - 31.9.2014 and i don't want to count them).

       

      The problem is that I have double quotes within other double quotes (in the first part of my code). I tried
      to change in brackets or other accent like ``. I also tried escape sequences, but it doesn't work.

       

      SOME IDEAS??

       

      Thanks in advance.