4 Replies Latest reply: Oct 6, 2011 4:14 AM by Andreas Dippel RSS

    text value condition in IF expression

    Andreas Dippel Oct 4, 2011 8:36 AM

      tryed to display data based on conditions

       

      1) if(Name='House1',Data,0)

      OR

      2) ({<Name = {'House1'}>} Data)

       

      it wont work, shows only "-".

       

      there is a stupid little mistake somewhere, but in the dokumentation, i only found IF or similar expressions, using nubers, NOT text values.

        • text value condition in IF expression
          Marc Livingston Oct 4, 2011 8:52 AM (in response to Andreas Dippel)

          Try if(lower(Name)='house1',Data,0)

           

           

          Make sure that the data returned by Name has no other characters or hidden spaces. Values must match exactly.

            • Re: text value condition in IF expression
              Andreas Dippel Oct 4, 2011 9:55 AM (in response to Marc Livingston)

              im sorry, that does not work. may be my example was too fuzzy.

               

              the table is like:

               

              ID; house; name; area; data; (header)

              1 ; house1; green; area1; 21; (data part)

               

              its a connection between "ID" and "variable" and value, so there are

              variable=house

              variable=name

              variable=area

              variable=data

               

              so its at least 4 times

              ({<variable = {'f.e. name'}>} value)

               

              so it displays the value for "name". worked fine before (with numbers, not text)

              ({<variable= {'1'}>} value)

               

              like:

              where (variable)='name', display (value)

                • Re: text value condition in IF expression
                  scottmc68 Oct 4, 2011 10:56 AM (in response to Andreas Dippel)

                  Using the word "only" at the beginning of the expression has worked for some similar things I have done.

                   

                  only({<Name = {'House1'}>} Data)

                    • Re: text value condition in IF expression
                      Andreas Dippel Oct 6, 2011 4:14 AM (in response to scottmc68)

                      thanks scottmc68,

                       

                      why does it make such a difference, if 'text' is used in expressions instead of numbers ?

                      its not even described in the ref guide. all examples there, are using numbers.

                       

                      this is a majo flaw in the documentation (dev course and ref guide)

                      1. why is it necessary to alter the expression ? cant we use one for text and numbers ?

                      2. why is there no example for text conditions ? its used pretty often in pivot tables.

                      3. why are there no "real" (longer than 2 lines) examples in the ref guide ? after looking up something in the ref guide, examples are only found in the course material.

                       

                      without the help of the community, QV would be much less usable.

                      thanks to everyone, you make this grat product usable.