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:
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.
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.
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?
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?