topic Re: Straight table expression to find multiples in QlikView

Straight table expression to find multiples

Tue, 14 Aug 2012 19:28:33 GMT

Hello,

I have one excel sheet containing: First Name, Last Name, Company, List Type, Importance. Basically I wanted to see what names (based on only first and last name) were on this list twice so i created a straight table with First Name and Last name as dimensions and the expression: if(count([Last Name]&[First Name])=2,'Both','Single'). So every name that is on the list twice comes up as Both. I also have a table box containing everything from the excel doc. This seemed to work fine except once i clicked on something in the table box, the straight table doesn't work correctly. For example, Importance has rankings 1 to 3 and when i click on a 1 in the table box the straight table does not show which people ranked 1 are on the list twice, it just reverts all names to Single. Is there a better expression to use?

Re: Straight table expression to find multiples

Gabriel — Wed, 15 Aug 2012 13:48:33 GMT

Hi,

My understanding of what you wanted is, if you select (importance) 1, then you want to see list of name associate with importance 1.

If this is the correct, then I will suggest having a LIST box on the sheet, with First Name & Last Name concatenated. So if you select 1 then you should see the list associated with the importance.

Let me know if this helps.

Gabriel

Re: Straight table expression to find multiples

Wed, 15 Aug 2012 17:54:08 GMT

Hi thanks for you suggestion. I have a straight table with just First Name and Last name and the expression i mentioned above so that i could see which names appeared twice in excel sheet. I also have a table box with all the attributes, Importance, Company etc. However when i click on importance 1, 2, or 3 the expression in my straight table no longer works.

Re: Straight table expression to find multiples

manojkvrajan — Wed, 15 Aug 2012 18:20:29 GMT

Please upload a sample QVW and let me have a look at it.

Re: Straight table expression to find multiples

Thu, 16 Aug 2012 15:12:06 GMT

I would rather make a new field in load script

...

FirstName & ' ' & LastName as FullName

...

And the used if(count( FullName )=2,'Both','Single')