Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps this?
=If(GetFieldSelections(_dates_RTT)='Month Yr',SubStringCount(Concat(If(IsNull(_dates_RTT), '1', _dates_RTT), '|'), 'Month Yr'),'0')
Perhaps this?
=If(GetFieldSelections(_dates_RTT)='Month Yr',SubStringCount(Concat(If(IsNull(_dates_RTT), '1', _dates_RTT), '|'), 'Month Yr'),'0')
Brilliant
Thank you, this works a treat!
Kind Regards
Helen
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
Thanks Sunny
That was going to be my next question, this works for me
Kind Regards
Helen
Glad it helped