How to excluded null values(-) in Set analysis

[Anonymous]

Hi ..

I have one field with null values means -.i have remove null values in set analysis.

please find following attachment i has agentskill targetid it contains null i have to remove null values in set analysis.

please help me..

Thanks,

[abhaysingh]

if null value coming from your backend data than you can remove it from your backend table with the help of where Condition, i.e. FieldName = ' ';

or

in Set analysis

sum(field = { * }- { 'Flag1'}- {'Flag 2'} and so on please mention all flag.

NOTE : -ve or +ve in Set analysis is up to your need

regards

Abhay

[jagan]

Hi,

Check this expression

=Only({<AgentSkillTargetID=P(AgentSkillTargetID)>} AgentSkillTargetID)

Regards,

Jagan.

[Anonymous]

Chandidni,

I do not see any reason doing this by SET Analysis, you simply select the "Suppress Null Values" option from the Dimension properties for a particular dimension.

Why you want to do it by SET only?