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: 
hugmarcel
Specialist
Specialist

New IDEA: Create master items (dimensions, measures) in script

Hi

We are currently using QlikView, and here lots of KPIs (formulas) and dimensions (table fields).

The KPIs and dimensions are stored in an Excel file as meta data.

What we are definitely missing is the possibility to create master items within QSense script!

The current possibilities need manual work or using the API. The first option is not feasible having lots of KPIs and dimensions. And if changes apply, manual work must be re-done over and over.


The second one needs setting up a development area to handle JSON, API Calls etc. We do not want this. As e.g. for JSON, an additional transformation layer to get the correct input will be needed.

Check also these resources regarding the issue:
- https://community.qlik.com/docs/DOC-8864#comment-36907
- https://community.qlik.com/message/738830#738830
- https://community.qlik.com/message/607828#607828
- https://community.qlik.com/message/831776#831776

Thanks a lot and regards - Marcel

19 Replies
Michael_Tarallo
Employee
Employee

Hello All - I was notified of this post from the last update - and it got me thinking about the DERIVE and DECLARE keywords. So I believe it is technically possible to create dimensions (and maybe measures) in this matter today using Qlik Script - I know that this framework is in place and is being improved upon - you can learn more about it here:

Derive: http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Scripting/derived-fie...

Declare: http://help.qlik.com/sense/2.1/en-US/online/#../Subsystems/Hub/Content/Scripting/ScriptRegularStatem...

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
vadimtsushko
Partner - Creator III
Partner - Creator III

Interesting and nice feature, Michael.

But is it related somehow to master items?

Documentation states that derived fields would appear in field list - would they appear also in master items panel and consequently in library?

And I can not see altogether how that feature could be used to create any measure. Could you provide some example for that?

Michael_Tarallo
Employee
Employee

I will find out

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

Hi Vadim,

You are correct, I got confirmation - at the moment - derive and declare only populate the field list level and the original intention for the feature is to categorize date / time dimensions. Thought the underling framework could be used for other dimensions, it is not intended to do so yet. There is discussion about auto-populating the master-items list, but it is not on the roadmap at this time.

Regards,

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
vadimtsushko
Partner - Creator III
Partner - Creator III

Thank you for clarification.

Not applicable

Hi Roberto,

I like this approach and want to test it.I just want to load the XML file with expressions and not load the .xmlscript or the csv. Is it possible? I have my data loaded already thru odbc. When i tried on FastTrack it's not loading .xml but complaining about missing .xmlscript file.

Not applicable

I will wait for your response on .xmlscript question I had asked in your earlier post but now, I was able to generate the measures and dims using the xml on my Qlik Sense Desktop. Works like a charm and i'm really amazed. I have couple of follow-up questions:

1. Is there a way we can automate this process? Can FastTrack consume an input as webservice etc

2. How to publish dims/meas to server automatically?

Really appreciate your help here! Thank you!

Not applicable

The .xmlscript is a mandatory file but you Can leave it empty

Inviato da Samsung Mobile.

Not applicable

Thanks Roberto, will do. I also have few additional questions:

I was able to generate the measures and dims using the xml on my Qlik Sense Desktop. I have couple of follow-up question:

Is there a way to publish master items thru XML to a server? I basically want to automate this process, probably using FastTrack components I want to push XML as webservice or something and load this to a Qlik server. Is it possible?

Really appreciate your help here! Thank you!

Not applicable

Hi,

I was just wondering if we have an approach to create master items on Qlik Sense server? I'm trying to investigate this further and any help on this subject is much appreciated.