topic Re: double quote wrapper in double code issue in set analysis in QlikView

double quote wrapper in double code issue in set analysis

gzboy008 — Thu, 16 May 2013 16:17:46 GMT

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~

Re: double quote wrapper in double code issue in set analysis

Gysbert_Wassenaar — Thu, 16 May 2013 16:31:07 GMT

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 [ ].

Re: double quote wrapper in double code issue in set analysis

gzboy008 — Thu, 16 May 2013 23:35:37 GMT

It works !

Thanks for help