Discussion Board for collaboration related to QlikView App Development.
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:
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.
Have you seen this post by David Foster
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