topic Re: Text box help using IF function in QlikView

Text box help using IF function

Fri, 28 Jun 2013 20:24:43 GMT

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

Re: Text box help using IF function

Fri, 28 Jun 2013 20:37:37 GMT

if you add a false branch eg

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

what happens?

Re: Text box help using IF function

Fri, 28 Jun 2013 20:43:25 GMT

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

Re: Text box help using IF function

Fri, 28 Jun 2013 20:46:06 GMT

check your case.... KEY1 not Key1

Re: Text box help using IF function

Fri, 28 Jun 2013 20:52:23 GMT

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

Re: Text box help using IF function

swuehl — Fri, 28 Jun 2013 20:55:57 GMT

Try

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

Re: Text box help using IF function

Mon, 01 Jul 2013 02:23:35 GMT

Worked like a charm! Thank you!