sub sql

[#1]

Hi,

Exists this the same SQL command  or similar in qlikview, in load  or in set analysis?

SELECT TEXT,

                (SELECT SUM(TOTAL) AS TOTAL FROM X AS Y WHERE Y.TEXT LIKE X.TEXT + '%' ) AS TOTAL

FROM X

[#2]

Very clever! I like your solution.