Dynamic report with dynamic metric variable loaded from filename

[#1]

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.

[#2]

Any ideas? 

[Colin-Albert]

Have you seen this post by David Foster

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

[#4]

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