Help with IF Statement text box

ivandrago — Mon, 05 Mar 2012 22:42:08 GMT

Hi,

I have the attached Document, I want the text box to show the word 'Open and Closed', this will only appear when the Status Open and Closed is selected.

Thanks

Help with IF Statement text box

swuehl — Mon, 05 Mar 2012 22:54:35 GMT

If you want to stay close to your current idea, you can use

=If(Match(GetFieldSelections( Status),'Closed, Open'),'Open and Closed: ')

to get the text printed if both values are selected, or

=If(Match( Status,'Closed','Open'),'Open or Closed: ')

will print the text if either Open or Closed is selected, but not both.

Hope this helps,

Stefan

topic Help with IF Statement text box in QlikView

Help with IF Statement text box

Help with IF Statement text box