topic Set Analysis Expression Filter doesn't work together with a Link Expression in QlikView

Set Analysis Expression Filter doesn't work together with a Link Expression

Thu, 06 May 2010 02:10:53 GMT

I have created a set analysis expression to filter my data into two straight tables, one each for men's and women's apparel.

Each table has a Link expression as we want to go to a site (not a valid site, this is just for testing) to view the details.

The filter works well if we do not have a link defined (disabled). When I enable the link, it displays all Product Categories (Men and Women) and somehow disregards the set analysis filter. Is this a bug or is it just the way QV works ?

Ultimately, the requirement is to have 2 separate straight tables , one for men and one for women, and both tables should have a link.

I am attaching a sample app for reference.

Set Analysis Expression Filter doesn't work together with a Link Expression

Thu, 06 May 2010 03:57:46 GMT

Hi Anthony,

You have to use the same condition for both the expression otherwise it will display all values. Or you can add the condition to the dimensions.

I have attached the application for your reference.

Regards

Rajesh

Set Analysis Expression Filter doesn't work together with a Link Expression

Thu, 06 May 2010 05:19:57 GMT

Hi Jayesh,

Thanks for the tip.

I removed the set analysis filter expression and the condition on the productID and it worked out fine. So I guess as long as one condition in the dimension is available, the filter would still work.

Thanks again.

Anthony

Set Analysis Expression Filter doesn't work together with a Link Expression

Thu, 06 May 2010 17:47:29 GMT

Hi,

When having lots of recs loaded, it looks like the IF statement uses a lot of memory as I get an "Allocated memory Exceeded" when I use that expression. However, I don't get the memory allocation error when I use Set Analysis to filter the data.

So my problem still exists. I am unable to use Set Analysis together with a link expression in a straight table. Using them together nullifies the set that was filtered on.

Anyone ?