topic Re: Re: Re: Re: Trigger - show only null values for a date field in QlikView

Trigger - show only null values for a date field

danielnevitt — Wed, 29 Oct 2014 10:11:40 GMT

Hi,

I have a field (fully_paid_dt) and I want to create a sheet trigger to only show where the field is blank. Currently the field displays a - if there is no date populated.

Any help with the above will be much appreciated.

Regards,

Daniel

Re: Trigger - show only null values for a date field

Gysbert_Wassenaar — Wed, 29 Oct 2014 10:18:36 GMT

I don't understand your question. Do you want to change the Null symbol from a - character to a blank? Do you want to filter a straight table (or pivot table) object so only the rows where the date field has no value are displayed?

Re: Trigger - show only null values for a date field

danielnevitt — Wed, 29 Oct 2014 10:21:55 GMT

Hi Gysbert,

Thank you for your reply.

I would like to filter a straight table object so only the rows where the date field has no value are displayed.

Regards,

Daniel

Re: Re: Trigger - show only null values for a date field

ashfaq_haseeb — Wed, 29 Oct 2014 10:28:51 GMT

May be like this.

Regards

ASHFAQ

Re: Trigger - show only null values for a date field

Gysbert_Wassenaar — Wed, 29 Oct 2014 10:34:55 GMT

Ok, you can change the expressions in your straight table. For example sum(Sales) would become sum({$<MyDate -= {'*'} >}Sales). That should filter out any non-null value and leave only the nulls.

Re: Re: Trigger - show only null values for a date field

danielnevitt — Wed, 29 Oct 2014 10:56:19 GMT

Hi,

The above is returning no results.

Below is the code I used:

sum({$<fully_paid_dt -= {'*'} >}amount_due_in_pay_curr)

Are you able to advise what the issue might be?

Thanks,

Daniel

Re: Trigger - show only null values for a date field

ashfaq_haseeb — Wed, 29 Oct 2014 11:02:57 GMT

Try like this

If not post sample application

sum({$<fully_paid_dt ={''}- {'*'} >}amount_due_in_pay_curr)

Regards

ASHFAQ

Re: Re: Trigger - show only null values for a date field

Gysbert_Wassenaar — Wed, 29 Oct 2014 11:50:27 GMT

Then perhaps your - values are not nulls but actual - characters. Try sum({$<fully_paid_dt = {'-'} >}amount_due_in_pay_curr)

Re: Re: Trigger - show only null values for a date field

danielnevitt — Wed, 29 Oct 2014 17:14:21 GMT

Hi,

Unfortunately the above do not work.

I have tried to use voucher_num instead of fully_paid_dt and I am still having the same issue. voucher_num is an integer and appears as - in my data when the field is not populated.

I do really appreciate your help with this issue.

Regards,

Daniel

Re: Re: Trigger - show only null values for a date field

Gysbert_Wassenaar — Wed, 29 Oct 2014 17:15:25 GMT

Can you post a document that demonstrates the problem?

Re: Re: Re: Trigger - show only null values for a date field

danielnevitt — Wed, 29 Oct 2014 17:54:58 GMT

Hi,

I have attached a file.

If you could show me how to create a table where:

1) voucher_num equals -

2) voucher_num not equal to -

Thanks,

Daniel

Re: Re: Re: Re: Trigger - show only null values for a date field

ashfaq_haseeb — Wed, 29 Oct 2014 18:06:05 GMT

Like this.

Have a look at attached application

Regards

ASHFAQ

Re: Re: Re: Re: Trigger - show only null values for a date field

ashfaq_haseeb — Wed, 29 Oct 2014 18:11:18 GMT

Hi,

1) voucher_num equals -

=sum(extended_amt)-sum({$<voucher_num ={'*'} >}extended_amt)

2) voucher_num not equal to -

sum({$<voucher_num ={'*'} >}extended_amt)

Regards

ASHFAQ

Re: Re: Re: Re: Trigger - show only null values for a date field

danielnevitt — Thu, 30 Oct 2014 10:23:48 GMT

Thank you both for your help.

I decided to SET NullDisplay='-' to simplify the selections (as I have Null values on several different fields). I then used the original code you both provided.

Regards,

Daniel

Re: Trigger - show only null values for a date field

ashfaq_haseeb — Thu, 30 Oct 2014 10:40:24 GMT

Glad To know

Regards

ASHFAQ