-
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.
-
-
-