topic Re: Get specific data from a Table in QlikView

Get specific data from a Table

Anonymous — Wed, 10 Oct 2012 16:22:37 GMT

Dear All,

I´m with a doubt of how to get a specific data from a table.

I have a table like it:

Field 1 | Field 2 | Field 3

Brasil Rio de Janeiro 1

Argentina Buenos Aires 2

Mexico Mexico City 3

I wrote a statement in a text box like bellow and I´m not geting the expected result ( " 1 " ), I´m getting a "-" character.

=IF([Field 1]='Brasil'

and [tField 2]='Rio de Janeiro', [Field 3])

If I select in a pivot table Brasil, it works.

Best Regards,

André

Re: Get specific data from a Table

Wed, 10 Oct 2012 18:24:02 GMT

Initial guess is that you have spaces that you are not accounting for in your if statement.

try this

IF( trim([Field 1])='Brasil'

and trim([Field 2])='Rio de Janeiro', [Field 3])

not sure if 't' in field 2 was a mistype or not. if not that could be your problem.

Re: Get specific data from a Table

Anonymous — Wed, 10 Oct 2012 19:08:15 GMT

Klangley,

It did not work. The problem is not the word comparision. The problem is to select an specific data in a table.

Thanks the help.

Best Regards,

Re: Get specific data from a Table

Thu, 11 Oct 2012 07:32:57 GMT

Hi,

for that purpose you can use set analysis. Set this expression as text in text object:

=Only({$<[Field 1] ={"Brasil"}, [Field 2] ={"Rio de Janeiro"}>} [Field 3])

regards

Re: Get specific data from a Table

Anonymous — Thu, 11 Oct 2012 08:08:23 GMT

Krunoslav,

Thanks the help but it did not worked. Same problem.

Rgds

Re: Get specific data from a Table

Thu, 11 Oct 2012 08:18:29 GMT

Can you attach qv file that you are working on?

Re: Get specific data from a Table

Anonymous — Thu, 11 Oct 2012 08:38:24 GMT

See attached a qvw with the problem. See that if you select Brasil in the tabel the Field 3 appears in the text box.

Thanks in advance,

Rgds,

Re: Get specific data from a Table

Thu, 11 Oct 2012 08:53:01 GMT

If I understand it correctly, text object should always displays value for Field 3, where Field 1=Brasil and Field 2=Rio de Janeiro. Text object in attachment is set this way, with assumptition that there is only one record in the data model table with values Field 1=Brasil and Field 2=Rio de Janeiro.

regards

Re: Get specific data from a Table

Anonymous — Thu, 11 Oct 2012 12:17:57 GMT

Krunoslav,

Yes, this is the point !!! Thanks.

Regards,

André