topic Re: Dynamic report with dynamic metric variable loaded from filename in QlikView

Dynamic report with dynamic metric variable loaded from filename

Thu, 09 Jan 2014 13:26:15 GMT

Hi,

I've created a dynamic report with the =SubStringCount(Concat(_Metric, '|'), 'Actual $') approach and it's working fine.

Now I've been trying to make it a bit more dynamic so that each Expression doesn't have to be hard coded.

I've loaded the filename for each forecast which are in xlxs files.

Metric2:
Load
FileBaseName() as _Metric
FROM

(ooxml, no labels);

Then I've created a variable that says:

vMetric =_Metric

Then I've tried to reuse that variable when displaying the different Expressions:

=SubStringCount(Concat(_Metric, '|'), $(vMetric))

Can't get it to work though, don't know if I need to use peek or order function to loop through the created values in the variable or if I'm just not thinking straight.

Has anyone done this?

Any help would be appreciated.

Re: Dynamic report with dynamic metric variable loaded from filename

Wed, 14 May 2014 22:25:53 GMT

Any ideas?

Re: Dynamic report with dynamic metric variable loaded from filename

Colin-Albert — Wed, 14 May 2014 22:31:06 GMT

Have you seen this post by David Foster

http://community.qlik.com/docs/DOC-6464

Re: Dynamic report with dynamic metric variable loaded from filename

Wed, 14 May 2014 22:57:43 GMT

No, haven't seen that. Without having tried it in practice it looks like exactly what I'm looking for!

Thanks a lot!

I've got some experimenting to do