Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

SubStringCount showing 0 , when multiple value . Need suggestion if value matches then show .

Hi there,

Initally in section access for variable ACCESSDETAIL I do have 'Y' and 'N'.

With that a text box use to show when the value is "Y"

thus in the layout condition - this expression is used

 =SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))

 

But now the scenario change , like ACCESSDETAIL can have value like 

ashmitp869_0-1655878389200.png

 

So now when a user have this three value , this expression is not working

 =SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))

My req is, if ACCESSDETAIL contain "Y" , then the condition or expression should work -

=SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))

 

Any suggestion,

 

Labels (2)
0 Replies