Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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