Null values with Substring(concat statement

[helen_pip]

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

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

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

[helen_pip]

Brilliant

Thank you, this works a treat!

Kind Regards

Helen

[sunny_talwar]

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

[helen_pip]

Thanks Sunny

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

Kind Regards

Helen

[sunny_talwar]

Glad it helped