topic Re: Not equal issue in set analysis - old version updated to newer version in QlikView

Not equal issue in set analysis - old version updated to newer version

Fri, 15 Feb 2013 08:31:42 GMT

Hi all,

I hope somebody can assist me with my issue.

I had version 9 point something on my pc until recently and yesterday I got version 10.

I have the following expression that was working perfectly in version 9 but now is coming through as an error expression:

sum({<Year <> {}, Month <> {}, NewRepeat <> {}, vSHID={}>}Dev_Pop_Percentage)

I tried using '-=' instead of '<>' but that does not work either.

Thanks in advance for any responses.

Re: Not equal issue in set analysis - old version updated to newer version

sushil353 — Fri, 15 Feb 2013 08:39:59 GMT

Hi,

Set analysis seems to be wrong. Can u specify functionality you want from this set analysis.

you cant use like Year <> instead try Year={"<>"}

HTH

Sushil

Re: Not equal issue in set analysis - old version updated to newer version

Fri, 15 Feb 2013 09:17:22 GMT

Hi,

Thanks for replying.

I hear what you saying about the syntax but the expression worked perfectly on my previous version. After my update it stopped working.

Some background into my data:

I have data that can be further split into 4 segments. Each segment has a score with differing score bands.

Each segment has development data according to their respective score bands that I want to compare to my current data by the same scorebands.

What the expression is meant to do is take the development data for each segment and keep those values constant irrespective of any further selections I make. So what I mean by this is that if I select segment A the development data will switch to segment A's data. If I then select month = September and year = 2011 the development data should not change.

If I select segment B the development data should change to B's data' Any further selections should not affect this data.

This was working before but now it seems to be broken.

I hope this clarifies things for you.

Re: Not equal issue in set analysis - old version updated to newer version

sushil353 — Fri, 15 Feb 2013 09:43:04 GMT

Try this expression. even it will work in your previous version

sum({<Year={1}, Month= {1}, NewRepeat = {1}, vSHID={}>}Dev_Pop_Percentage)

HTH

Re: Not equal issue in set analysis - old version updated to newer version

Fri, 15 Feb 2013 10:32:42 GMT

When I try that it just returns zero values for all the scorebands.

Scoreband is my dimension.

Re: Not equal issue in set analysis - old version updated to newer version

Mon, 25 Feb 2013 15:46:01 GMT

Let's say 'Excluded' is what you don't want:

sum({<Year = {'*'}-{'Exclude'}>}Dev_Pop_Percentage)

Does that work?

Re: Not equal issue in set analysis - old version updated to newer version

saumyashah90 — Thu, 17 Oct 2013 10:35:08 GMT

what if i have field name to compare instead of value

Re: Not equal issue in set analysis - old version updated to newer version

CELAMBARASAN — Thu, 17 Oct 2013 10:41:39 GMT

Try this

sum({<Year=, Month=, NewRepeat=, vSHID= >}Dev_Pop_Percentage)

Re: Not equal issue in set analysis - old version updated to newer version

Thu, 17 Oct 2013 10:45:24 GMT

try this:

,~ NewRepeat = {},

Re: Not equal issue in set analysis - old version updated to newer version

Thu, 17 Oct 2013 10:46:34 GMT

try this:

sum({<Year <> {}, Month <> {}, ~ NewRepeat = {},vSHID={}>}Dev_Pop_Percentage)