Text box help using IF function

[#1]

I am very new to Qlikview, I am used to writting static reports, but Qlikview is a different way of thinking (which I like!)

I am looking for help in focusing multiple rows into each of their own text boxes. So after I have clicked to select my project I now have multiple lines of data from a table. I would like to focus each line into it's own Text box, for formatting purposes.

To start off i have tried to enter this if statment in the one text box. =if(LongText.Key1='nem_project_scope',LongText.LINE_TEXT). It just gives me a - mark in the text box.

Any help to straighten me out would be appreciated. Let me know if you need more detail.

Thank you in advance

Bryan

[#2]

if you add a false branch eg

=if (LongText.Key1='nem_project_scope',LongText.LINE_TEXT, '???')

what happens?

[#3]

Making progress...It now displays ??? in the textbox.

I have a table box directly below it and it displays the 6 different values one of which is the nem_project_scope

[#4]

check your case.... KEY1 not Key1

[#5]

Still the same result, to be sure i had it correct, i went in and did paste field.

[swuehl · Accepted solution]

Try

=only({<LongText.KEY1 = {'nem_project_scope'}>} LongText.LINE_TEXT )

[#7]

Worked like a charm! Thank you!