topic Re: Null values with Substring(concat statement in QlikView

Null values with Substring(concat statement

helen_pip — Fri, 19 Jan 2018 12:58:43 GMT

Dear Qlikview User

I have attached a copy of a QVW which illistrates my issue

In the text object I have written an expression which should show 0 when Month Yr is not selected from list box. However I expected the expression to be 0 when I take off all my selections from the list box

Could someone kindly take a look and let me know where I may have gone wrong with the expression as I would like the expression to show 0 when nothing in the list box is selected

Kind Regards

Helen

Re: Null values with Substring(concat statement

Anil_Babu_Samineni — Fri, 19 Jan 2018 13:04:45 GMT

Perhaps this?

=If(GetFieldSelections(_dates_RTT)='Month Yr',SubStringCount(Concat(If(IsNull(_dates_RTT), '1', _dates_RTT), '|'), 'Month Yr'),'0')

Re: Null values with Substring(concat statement

helen_pip — Fri, 19 Jan 2018 13:08:26 GMT

Brilliant

Thank you, this works a treat!

Kind Regards

Helen

Re: Null values with Substring(concat statement

sunny_talwar — Fri, 19 Jan 2018 13:08:40 GMT

Or this

=If(GetSelectedCount(_dates_RTT) > 0, SubStringCount(Concat(If(IsNull(_dates_RTT), '1', _dates_RTT), '|'), 'Month Yr'),'0')

If you want to see 1 if two selections are made and one of them is Month Yr

Re: Null values with Substring(concat statement

helen_pip — Fri, 19 Jan 2018 13:33:40 GMT

Thanks Sunny

That was going to be my next question, this works for me

Kind Regards

Helen

Re: Null values with Substring(concat statement

sunny_talwar — Fri, 19 Jan 2018 13:38:02 GMT

Glad it helped