topic Re: How to suppress the null values in expression level in QlikView

How to suppress the null values in expression level

Wed, 25 Nov 2020 16:16:04 GMT

i need to suppress the null values based on expression

Thanks

siddiq

Re: How to suppress the null values in expression level

sunny_talwar — Wed, 11 May 2016 20:18:08 GMT

Not sure I understand, but may be like this....

If(Len(Trim(Expression)) > 0 , .....)

Re: How to suppress the null values in expression level

Wed, 11 May 2016 21:03:54 GMT

here expression field is depends on start time and end time

for example :

if start time is zero then it should not show in the chart

Re: How to suppress the null values in expression level

sunny_talwar — Wed, 11 May 2016 21:04:48 GMT

I am not still not sure I understand. Would you be able to upload a sample

Re: How to suppress the null values in expression level

Wed, 11 May 2016 22:26:20 GMT

i have the below image in that item number is dimension .start date and end date derived based on expression.here i have to suppress the null values.

For example:in the below chart i should not see itemno 103 and 104,101 because in these we have nulls.i need only one record i.e item 102 .but we should filter based on expression not based on dimension .

Re: How to suppress the null values in expression level

Thu, 12 May 2016 05:15:13 GMT

Can you elaborate more whether it is for Straight Table or Pivot Table to suppress the null values at expression level. So that we will help you shortly

Thanks

Reddi Kishor.

Re: How to suppress the null values in expression level

engishfaque — Thu, 12 May 2016 05:24:55 GMT

Dear Abubakar,

Exclude these values by using listed below Set Analysis Modifiers, these modifiers need to be add in your expression

[Start Date] -= {"=Null()"}, [End Date] -= {"Null()"}

Kind regards,

Ishfaque Ahmed

Re: How to suppress the null values in expression level

PrashantSangle — Thu, 12 May 2016 05:35:07 GMT

Hi,

What is your expression???

try like

sum(if(len(trim(startDate))>0,sales))

Kind Regards

Re: How to suppress the null values in expression level

Kushal_Chawda — Thu, 12 May 2016 05:42:32 GMT

=sum({<StartTime ={'*'},EndTime ={'*'}>}Value)

Meaning of * in set analysis is, give all the Values excluding *, Make sure that you have checked the "Suppress Zero Values" in presentation tab

Re: How to suppress the null values in expression level

phaneendra_kunc — Thu, 12 May 2016 05:58:17 GMT

U can do this in two ways.

1. On dimension tab enable SUPRESS NULL VALUES on StartTime and EndTIme fields.

2. add a expression Sum(if(len(StartTime)<>0 and len(EndTime)<>0, METRIC_FIELD))