Double quotes within double quotes in set analysis

Wed, 21 Oct 2015 06:31:10 GMT

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

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.

Re: Double quotes within double quotes in set analysis

Anonymous — Wed, 21 Oct 2015 06:51:11 GMT

try single qotes on the inner part ' instead of "

Re: Double quotes within double quotes in set analysis

Wed, 21 Oct 2015 10:43:58 GMT

I tried but it doesn't work..

Re: Double quotes within double quotes in set analysis

Tue, 01 Dec 2015 12:29:57 GMT

I was wrong. It works perfectly. Thanks

topic Re: Double quotes within double quotes in set analysis in QlikView

Double quotes within double quotes in set analysis

Re: Double quotes within double quotes in set analysis

Re: Double quotes within double quotes in set analysis

Re: Double quotes within double quotes in set analysis