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

[#1]

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.

[sushil353]

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

[#3]

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.

[sushil353]

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

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

HTH

[#5]

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

Scoreband is my dimension.

[#6]

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

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

Does that work?

[saumyashah90]

what if i have field name to compare instead of value

[CELAMBARASAN]

Try this

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

[#9]

try this:

,~ NewRepeat = {},

[#10]

try this:

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