topic Simple Question Primary Keys in QlikView

Simple Question Primary Keys

Thu, 27 Aug 2009 01:04:28 GMT

This is probably an easy one...

Prior to using qlikview, when I needed to create reports (e.g. ASP.NET), I'd create a drop down list where the value = primary key of a table and the text = the name

Let's say I have a customer dimension that has the following fields (custID int, custname)

When I create a ListBox, I want to display the custname. This is really easy. However, if two customers have the same name (very possible), I want to see two records in the ListBox.

How can I achieve this in Qlikview?

Thanks!

Simple Question Primary Keys

Thu, 27 Aug 2009 01:10:12 GMT

use a table box instead, and display custId and custname

Simple Question Primary Keys

Anonymous — Thu, 27 Aug 2009 03:39:26 GMT

Or, you can use straight table with custId as dimension and custname as expression, and hide custId. Looks more like listbox.

AW:Simple Question Primary Keys

biester — Thu, 27 Aug 2009 04:24:39 GMT

Or you could use a custom expression as e. g.

= custID & ' : ' & custname

as base of a ListBox.

At least theoretically this should work, but I'm afraid there's an issue with QlikView 9 with this ListBox Espression. I'll harangue the support team on this tomorrow ....

Rgds,
Joachim

AW:Simple Question Primary Keys

johnw — Thu, 27 Aug 2009 05:41:09 GMT

I sometimes load codes and descriptions into a single field in my script, either "description (code)" or "code - description" depending on whether the code or the description is more commonly used, or depending on how users are used to looking at the data in other systems. I'm guessing that a straight table is closer to what you're after here, though.

AW:Simple Question Primary Keys

Anonymous — Thu, 27 Aug 2009 11:17:10 GMT

Another approach is to use dual() to create a field for selecting the report in the script.

dual(CustomerName, CustomerID) as NameSelect

This way you will display all duplicates of CustomerNames as long as they have different underlying CustomerID's.

Simple Question Primary Keys

Thu, 27 Aug 2009 16:09:42 GMT

I prefer to use the listbox solution as search functionality is still available to the user; I also create a field like 'custno - custname'

Regards,

Gordon

Simple Question Primary Keys

Thu, 27 Aug 2009 22:34:19 GMT

Wow, clearly there are a lot of options. Thank you everyone!