only function small issue

[samuel_brierley]

Hi all,

recently the community itroduced me to the only( function in qlikview, works great but now i have a small issue.

my tables are imported from XML files. in one XML file it may say

parameter>tAgg

<description>Length of aggregation period</description>

<curval>CommonParameters.Group.tAgg</curval>

</parameter>

where  CommonParameters.Group.tAgg is another XML table somewhere else

when i import the 2 tables there are 2 Occurences of Length of aggregation period.

one CurVal states CommonParameters.Group.tAgg and the other states 20.

20 is obviously the value im after.

so after all that my query is, is there a way to perform an only function(or similar) that will only return the number and not the text.

Hopefully that makes sense

thanks

[hic]

I don't think the Only() function will solve your problem. But exactly what you need is difficult to say without having seen your data model or your app.

HIC

[samuel_brierley]

this was answered by a friend by quite simply adding another set analysis