double quote wrapper in double code issue in set analysis

[gzboy008]

Hi everyone,

In set analysis hand book, I saw this formula.

sum( {$<Customer = {"=Sum({1<Year = {2007}>} Sales )> 1000000"}>} Sales )

So I try to use this formula in my development work.

Unlike this formula exactly, I need to use double quote search the result. The situation likes double quote wrapped in double quote.

For instance, I don't want to retrieve some specified year's sale, I want a time range to instead.

But if I use double quote in double quote, it doesn't work. Seems Qlikview fail to recognise it's double quote wrapped in double quote.

Here's what I want. I want to search Year is greater than 2007 and the sales amount is larger than 1000000, but it doesn't work. It failed to recognise the double quote wrapper in double quote. So the search can not carry out and compiling error occurs. 

sum( {$<Customer = {"=Sum({1<Year = {">=2007"}>} Sales )> 1000000"}>} Sales )

Does anyone has a better solution?

Thanks~

[Gysbert_Wassenaar · Accepted solution]

You can use single quotes within the double quotes (and vice versa):

sum( {$<Customer = {"=Sum({1<Year = {'>=2007'}>} Sales )> 1000000"}>} Sales )

This allows you to nest set modifiers like above. Actually, according to this blog post more options are available like ` and [ ].

[gzboy008]

It works !

Thanks for help