topic Adding two rows in same table in QlikView

Adding two rows in same table

Wed, 25 Aug 2010 10:25:34 GMT

Hi,

I'm very new to qlikview and have a small query.

I have a table called LOCATION which contains about 800 locations. The format of text in this table is A-B-C.

There are 2 locations in the same table 1) A-B-C 2) A-E-F

I want to count all locations which contain B and E in the middle of the text.

Can you please help me in resolving this. It would be of great help.

Adding two rows in same table

llauses243 — Wed, 25 Aug 2010 10:51:08 GMT

This is my offer, good luck, Luis

Adding two rows in same table

Thu, 26 Aug 2010 04:43:43 GMT

I got one step where I can get the sub location.

However I'm not able to reaqch the second step. I also want to add some sub-locations (e.g. all CMU, PLANT, Plant SU/Plant should display as one.....AO, RO, BO should display as one)