topic Re: text value condition in IF expression in QlikView

text value condition in IF expression

Tue, 04 Oct 2011 12:36:53 GMT

tryed to display data based on conditions

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

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

Tue, 04 Oct 2011 12:52:19 GMT

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

Tue, 04 Oct 2011 13:16:50 GMT

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

Tue, 04 Oct 2011 14:56:05 GMT

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

Thu, 06 Oct 2011 08:14:23 GMT

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.