topic Additional filter on field already filtered using Set Analysis in QlikView

Additional filter on field already filtered using Set Analysis

Anonymous — Tue, 19 Apr 2011 13:51:00 GMT

sum({<Year={2010,2011}>}Amount)

Above is working fine. However, when the user Clicks on Year 2011, filter is not applied. I got around the problem by getting 2 fields, Year and YearRenamed in the load statement. I used Year in the set analysis and displayed YearRenamed for the user to further filter.

Is there a better solution? I would rather not have additional field YearRenamed to keep it clean.

Thanks,

Dinesh.

Additional filter on field already filtered using Set Analysis

erichshiino — Tue, 19 Apr 2011 13:54:15 GMT

sum({}Amount)

Additional filter on field already filtered using Set Analysis

Anonymous — Tue, 19 Apr 2011 14:01:25 GMT

I cannot remove the set analysis as I need to avoid all the previous years prior to 2010 to begin with. At the same time, I need to give the user further ability to filter 2010 or 2011.

Regards,

Dinesh.

Additional filter on field already filtered using Set Analysis

erichshiino — Tue, 19 Apr 2011 14:12:13 GMT

Sorry, There was something wrong with quick reply:

Try:

sum({<Year*={2010,2011}>}Amount)

This will be the intersection between user selection and 2010, 2011

So, if user select 2010, he will get only 2010. If he selects 2009, gets 0

Hope the post works now...

SV:Re: Additional filter on field already filtered using Set Analysis

gandalfgray — Tue, 19 Apr 2011 14:17:00 GMT

Hi Dinesh

Try this:

sum({$*<Year={2010,2011}>} Amount)

Additional filter on field already filtered using Set Analysis

Anonymous — Tue, 19 Apr 2011 14:50:56 GMT

Thx Erick and Goran. Both your suggestion works, however I like Erick's option better as it is easier to read from a maintenance perspective. My only concern is that the editor shows as a red squiggly line giving a wrong impression that there is a syntax error.

Regards,

Dinesh.

Additional filter on field already filtered using Set Analysis

erichshiino — Tue, 19 Apr 2011 14:55:46 GMT

in QV 10 I also got some "syntax errors" like this. I guess some structures are not recognized yet.

For example, noconcatenate is not recognized on the script.