How to enable ODAG to dynamically select a QVD (1 of thousands) based upon end user filtering?

[Bujarski]

Qlik Sense Nov 2021

Created thousands of QVD to create smaller checks of data.  Summary level works very well, great performance

ODAG, 

2 options (?);

1.  Concatenate all the qvds into a single massive qvd.  Actually worked, however, ODAG processing is extremely slow

2.  ODAG dynamically select the qvd based on end user filters?

Summary app has 3 filters,  Period, Company and State.  QVD's are created by same, Period, Company and State so thinking it should be possible and if so, any help/suggestions are appreciated!

[Or · Accepted solution]

You should be able to use the dynamic approach, e.g.

Let vQVDName = $(od_PERIOD) & $(od_Company) & '.qvd';

Load * From '$(vQVDName)';

Syntax might need adjusting since I wrote it blind, but this approach is something I use regularly.

[Bujarski]

Thank You,  I'll test this out and reply in kind

[Bujarski]

Thank You so much,  some back and forth with the syntax,  but we got it working!