Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Dynamic report with dynamic metric variable loaded from filename

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.

3 Replies
Not applicable

Re: Dynamic report with dynamic metric variable loaded from filename

Any ideas? 

Re: Dynamic report with dynamic metric variable loaded from filename

Not applicable

Re: Dynamic report with dynamic metric variable loaded from filename

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