Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

SubStringCount condition not working with more than one value

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-1655881252576.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))

 

When selecting a user the ACCESSDETAIL value is N OR Y

ashmitp869_1-1655881375770.pngashmitp869_2-1655881433304.png

 

But in this scenaio,it having more that one value 

ashmitp869_3-1655881489334.png

 

How to pick Y in this case from this condition

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

Thanks in advance

 

Labels (2)
0 Replies