2 Replies Latest reply: Aug 26, 2010 12:43 AM by VIRAL DEDHIA RSS

    Adding two rows in same table

      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.