topic Re: Table wild cards in QlikView

Table wild cards

Anonymous — Mon, 17 Sep 2012 15:29:26 GMT

Hi guys,

I have a table with a list of customer info, here are some examples:

Bob Bates

Sid Roberts

James Jones

Bob Smith

Ed Jacobs

How can I analyze this table and make a graph showing how many of each forename we have in the table? The graph would show I have 2 bobs, 1 sid, 1 james and 1 ed

Thanks!

Re: Table wild cards

Miguel_Angel_Baeyens — Mon, 17 Sep 2012 15:33:50 GMT

Hi,

Using

SubField(CustomerName, ' ', 1)

will return this first name. You can store this into a new field and use later on on a chart.

Hope that helps.

Miguel

Re: Table wild cards

Anonymous — Mon, 17 Sep 2012 15:36:55 GMT

Where does that go? Graph or code?

Re: Table wild cards

Mon, 17 Sep 2012 15:42:08 GMT

Hi,

By using Subfield function,

SubField(Cust,' ',1) as FirstName

see the attach qvw.

Regards

Yigal

Re: Table wild cards

Miguel_Angel_Baeyens — Mon, 17 Sep 2012 15:42:47 GMT

Hi,

If possible, always in the script, in the LOAD part, creating a new field.

Hope that helps.

Miguel

Re: Table wild cards

Anonymous — Mon, 17 Sep 2012 15:55:32 GMT

Thanks guys