Alternate State in expression condition

[Anonymous]

Hi all

I have condition in Pivot expression

SubstringCount(Concat(Qtr, '|'), 'Q1)'

and List box for Qtr (StateA) , so If I select Q1 than particular column display otherwise not.

How do I apply StateA (Alternate State) in above Substring command line

Thanks

[sunny_talwar · Accepted solution]

Try this:

SubstringCount(Concat({StateA}Qtr, '|'), 'Q1')

[Gysbert_Wassenaar]

Add a closing single quote after Q1: SubstringCount(Concat({StateA}Qtr, '|'), 'Q1')

Or try: max({StateA}match(Qtr,'Q1'))

[sunny_talwar]

Good catch

[Anonymous]

Works, Thanks guys

[Anonymous]

Works, Thanks guys

[sunny_talwar]

No problem