Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have many Qlikview dashboards that read from multiple data sources. The data sources are QVDs, Excel, Stored Procedures from SQL Server, Sharepoint, etc. Every time that a data source change its FIELD NAMEs, I have to go into every QVW and rename the fields by either applying the "Rename" command or by manually renaming each one of them. My questions is related to "automation" on how to make this long process automated and insulate our dashboard from "surprise" data field changes. The change in field names happen very often. How do you handle these changes when you have multiple Dashboard QVWs to maintain?
You can have one excel with two fields
Excel:
Qvw_FieldName,Source_Column_Name
Use this excel to rename fields while generating QVD.
Whenever there is a Change in column name.Simply go to excel and change the Source_Column_Name.
then store data into QVD.
This way you don't need to disturb actual applications.
Thank you for your reply! I had read this post but I think what I am looking for is an automated way to fix the issue that is already present. I currently have 27 dashboards that need to have many fields renamed. The “data source fields” have been renamed but the UI field names should remain the same. Having said that when I read the data from the “QVD” with new field names, the Dashboard QVW load fails because the data source field names have changed. Please keep in mind that the UI Names should remain the same as it was before the “data source field name” change. Thus, I was thinking of creating a “mid layer” QVW and have the renaming done by this QVW instead of on the Dashboard QVW. I would then change one variable value in my Dashboard QVW to read the “new renamed” QVD. Maybe this way I can rename the fields in all 27 dashboards without too much coding. I have not implemented or tested this idea. What do you think?
You can have one excel with two fields
Excel:
Qvw_FieldName,Source_Column_Name
Use this excel to rename fields while generating QVD.
Whenever there is a Change in column name.Simply go to excel and change the Source_Column_Name.
then store data into QVD.
This way you don't need to disturb actual applications.
if you rename only 1 field, it is automatically changed in the GUI.
I know it's hard work, but it is better to open the 27 dashboards.
Best Regards.
Tonial.
I this case it will be a lot of fields. Close to 60 or 70 fields.
Unfortunately I do not see any other way.
You have to change one by one and make the load of 27 dashboards for 60 or 70 times.
So do you mean to say my suggestion posted earlier and showing here is not a good idea?
Thank you for your reply! I had read this post but I think what I am looking for is an automated way to fix the issue that is already present. I currently have 27 dashboards that need to have many fields renamed. The “data source fields” have been renamed but the UI field names should remain the same. Having said that when I read the data from the “QVD” with new field names, the Dashboard QVW load fails because the data source field names have changed. Please keep in mind that the UI Names should remain the same as it was before the “data source field name” change. Thus, I was thinking of creating a “mid layer” QVW and have the renaming done by this QVW instead of on the Dashboard QVW. I would then change one variable value in my Dashboard QVW to read the “new renamed” QVD. Maybe this way I can rename the fields in all 27 dashboards without too much coding. I have not implemented or tested this idea. What do you think?