Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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