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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Condition with two functions


Hello, I´m trying to create a condition for a chart that only want to display when two values in the field "FieldOne" are selected, and those two values should be "BG" and "VG".

I´ve tried this, bud it doesn´t work

 

MinString(FieldOne='BG')

AND

MaxString(FieldOne='VG')

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try something like this

=GetFieldSelections(FieldOne,',') = 'BG,VG'

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
rbecher
MVP
MVP

=(MinString(FieldOne)='BG' AND MaxString(FieldOne)='VG')

- Ralf

Astrato.io Head of R&D
MayilVahanan

Hi

Try something like this

=GetFieldSelections(FieldOne,',') = 'BG,VG'

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
er_mohit
Master II
Master II

try this in condition

count(Distinct wildmatch(FieldOne,'BG') and wildmatch(FieldOne,'VG'))=1