topic Re: Displaying a Null Value in QlikView

Displaying a Null Value

Wed, 01 Jun 2016 19:51:33 GMT

Hi Friends,

Please let me know if any one can help me on the logic for the below.

Based on the "Group" selection we need to check the "FINAL" field whether it has any null values or not.If there is any one null value, We Need to Give a Message in a Textbox as " Yes final has a Nullvalue" or else " No null values".If no selection in the Group field the Text should display "Final field has null values or not" based on the same condition.

Let me know if i need to re frame the question.

Thanks and Regards,

Regards,

Pooja.

Re: Displaying a Null Value

sunny_talwar — Wed, 01 Jun 2016 20:07:15 GMT

May be this:

=NullCount(Aggr(Amount1*Amount2, No, Title, Item, Group, test))

Re: Displaying a Null Value

Thu, 02 Jun 2016 00:33:32 GMT

Hi Sunny,

Thank you so much for your valuable time.

The above script is working. But still i have a concern, why we need to check with all the fields. If i check only with the Group field the answer is not coming. Below is my edited code.

=NullCount(Aggr(Amount1*Amount2, Group)) > 0, 'Yes Final has Null', 'No Null Values')

Why i have this doubt is, in future if we are adding some more fields in the DB. do i need to add those fields also into this script right..!! So instead can we check the conditions only between these "Group" and "amount1*amount2" fields.

Hope you understood my query.

Regards,

Pooja

Re: Displaying a Null Value

sunny_talwar — Thu, 02 Jun 2016 17:19:42 GMT

I think the problem is that when you are aggregating on Group only, Amount1*Amount2 is always null.

May be you can try with this:

=If(NullCount(Aggr(Amount1*Amount2, Group, No)) > 0, 'Yes Final has Null', 'No Null Values')