Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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
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?
I will find out
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
Thank you for clarification.
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.
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!
The .xmlscript is a mandatory file but you Can leave it empty
Inviato da Samsung Mobile.
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!
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.