Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Creating a path for different files

Hello community, i have a dashboard that i want to use for different clients. My problem is that i always need to change the names of the qvd files in the script. Is there a way to create a path at the beginning of the script so i could change the name only once? 

This path should lead to a parameters file where i have a prefix of the files' name, that leads to all qvd files that start with the same prefix.

Thanks in advance

Ali

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

You can use the variable as a part of the qvd name. For example: Path\$(clientname)_sales.qvd (qvd); and for another table: path\$(clientname)_Purchases.qvd.

View solution in original post

5 Replies
Highlighted
Partner
Partner

Hi,

You can use variables. You can store them in Excel or in a notepad file or you can create a loop.

For example.

LET vClientName = X;

Table1:

LOAD * FROM $(vClientName).qvd (qvd);

Highlighted
Creator
Creator

thanks for replying, but using your script i need to create as many variables as files related to a specific client because i can only load one qvd

Highlighted
Partner
Partner

You can use the variable as a part of the qvd name. For example: Path\$(clientname)_sales.qvd (qvd); and for another table: path\$(clientname)_Purchases.qvd.

View solution in original post

Highlighted
Creator
Creator

ok thanks, appreciate the help

Highlighted
Creator
Creator

Hey Anton, you know how can i add a path to special sheet in muy excel file?

Thanks in advance