only function small issue

samuel_brierley — Wed, 28 May 2014 15:34:42 GMT

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

Re: only function small issue

hic — Wed, 28 May 2014 15:48:37 GMT

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

Re: only function small issue

samuel_brierley — Thu, 29 May 2014 06:49:52 GMT

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

topic only function small issue in QlikView

only function small issue

Re: only function small issue

Re: only function small issue