topic Re: How to excluded null values(-) in Set analysis in QlikView

How to excluded null values(-) in Set analysis

Anonymous — Fri, 21 Nov 2014 06:40:46 GMT

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,

Re: How to excluded null values(-) in Set analysis

sujeetsingh — Fri, 21 Nov 2014 06:44:08 GMT

You can try {*} to select all values that should exclude the null value and - {''} should get rid of the blank values.

=sum({$<resolveddate ={'*'}-{''}>} 1)

Re: How to excluded null values(-) in Set analysis

Anonymous — Fri, 21 Nov 2014 06:48:03 GMT

Hi Sujeet..

Thanks for yoyr reply

I tried this systax but its not working.Can you please find my attachment in this AGENTSKILLTARGET ID Contains null values i have to remove null values..Help me..

Thanks..

Re: How to excluded null values(-) in Set analysis

PradeepReddy — Fri, 21 Nov 2014 06:51:57 GMT

you can use NULLASVALUE in script in order to assign a string/numeric default value for nulls:

Script:

NULLASVALUE Filed;

Set NullValue = 'N/A';

Expression:

Count({<Field={'N/A'}>}Field)

Re: How to excluded null values(-) in Set analysis

PrashantSangle — Fri, 21 Nov 2014 06:53:55 GMT

Hi,

Try Like

Sum({<NullITakingField={"=not isnull(NullTakingField)"}>}Sales)

Regards

Re: Re: How to excluded null values(-) in Set analysis

Anonymous — Fri, 21 Nov 2014 06:58:38 GMT

Hi Max..

Thanks for your reply..

If apply same syntax it does not working fine..

Thnaks,

Re: Re: How to excluded null values(-) in Set analysis

anbu1984 — Fri, 21 Nov 2014 06:59:49 GMT

Check this

Re: How to excluded null values(-) in Set analysis

PrashantSangle — Fri, 21 Nov 2014 07:11:15 GMT

Hi,

What is your expected count??

Regards

Re: Re: Re: How to excluded null values(-) in Set analysis

Anonymous — Fri, 21 Nov 2014 07:13:45 GMT

Hi Anbu..

Thanks for your reply..

Trasing wise your formula currect.But when i create table box with acdDATE and agentskilltargetID.The agentskilltargetid has null values so it has count but your formula shows zero count..

Please help me

Re: How to excluded null values(-) in Set analysis

anbu1984 — Fri, 21 Nov 2014 07:23:55 GMT

=count({<ACD_Date={'=Len(Trim(AgentSkillTargetID))=0'}>}DISTINCT ACD_Date)

Re: How to excluded null values(-) in Set analysis

abhaysingh — Fri, 21 Nov 2014 07:24:58 GMT

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 = ' ';

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

Re: How to excluded null values(-) in Set analysis

jagan — Fri, 21 Nov 2014 07:27:11 GMT

Hi,

Check this expression

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

Regards,

Jagan.

Re: How to excluded null values(-) in Set analysis

Anonymous — Fri, 21 Nov 2014 07:51:34 GMT

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?