Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QinggangMa
Contributor
Contributor

QlikSense - Loading dimension and measure definitions from file using scripts

I've been supporting some qlikview dashboards. The views start with a template and loading data using VB scripts. One part of the scripts loads dimension and measure definitions from an excel file.  The scripts is like this,

all_dimensions_table:
LOAD dimension as %all_dimensions
FROM
$(dimensions_file)
(ooxml, embedded labels, table is dimensions);

measures_00:
LOAD measure as %measure_00,
type as %type_00,
formula as %formula_00,
format as %format_00
FROM
$(dimensions_file)
(ooxml, embedded labels, table is measures);

I am now looking to move to QlikSense. I tried to put the scripts into QLikSense directly and ran it. It did not complain and loaded the file in. However, it did not create the dimensions and measures, rather, it seemed that it just treatsed them as regular data tables.

Is there something similar in QlikSense that allows me to load dimension and measure definitions from a file using scripts?

Thanks

Labels (1)
2 Replies
abhijitnalekar
Specialist II
Specialist II

Hi,

Would like to clear some doubts.

1. Are you using the same data model which is used in Qlikview.

2. how you are using the definition field in the dashboard. 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
QinggangMa
Contributor
Contributor
Author

To answer the questions,
1. Are you using the same data model which is used in Qlikview.

I am trying to load the definitions to create the same data model as I have in qlikview

2. how you are using the definition field in the dashboard.

From the $(dimensions_file) file, I load up dimension and measure definitions and then they are used in a filter, chart, or a pivot table etc. 

The purpose of loading dimensions and measures from the file is to save time and trouble for defining them manually through the UI. Also once it is defined in a file, you can easily load it into a dash by copying the same loading scripts