Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

1 Solution

Accepted Solutions
hrlinder
Honored Contributor

Re: Double quotes within double quotes in set analysis

try single qotes on the inner part ' instead of "

3 Replies
hrlinder
Honored Contributor

Re: Double quotes within double quotes in set analysis

try single qotes on the inner part ' instead of "

Not applicable

Re: Double quotes within double quotes in set analysis

I tried but it doesn't work..

Not applicable

Re: Double quotes within double quotes in set analysis

I was wrong. It works perfectly. Thanks

Community Browser