Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Straight table expression to find multiples

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?

4 Replies
Gabriel
Valued Contributor II

Re: Straight table expression to find multiples

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

Not applicable

Re: Straight table expression to find multiples

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.

manojkvrajan
Contributor III

Re: Straight table expression to find multiples

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

Not applicable

Re: Straight table expression to find multiples

I would rather make a new field in load script

...

FirstName & ' ' & LastName as FullName

...

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

Community Browser