topic Re: How to create Drill-Down Dimension via Scripting? in QlikView

How to create Drill-Down Dimension via Scripting?

Thu, 30 Mar 2017 11:19:57 GMT

Hi,

is there a possible way to create Drill-Down Dimensions in the Load Script in QlikView?

I read that it is not possible in Qlik Sense and therefore I'm interested in QlikView because I have a lot dimensions. It would take a Long time to create them all manually.

With best regards!

Re: How to create Drill-Down Dimension via Scripting?

vinieme12 — Thu, 30 Mar 2017 11:52:11 GMT

Hierarchy in QlikView

Re: How to create Drill-Down Dimension via Scripting?

Thu, 30 Mar 2017 12:05:08 GMT

Thank you. But I have a few questions left:

I don't really get the difference between drilldown-Dimension and hierarchy in Qlik. But is it the same in QlikSense and QlikView?

I always thought that hierarchy or hierarchybelongsto in the LOAD Script would create a suitable table. But I have tables which are fine to use as a drilldown Dimension.

Like the drilldown Dimension in QlikSense is a Master Element, I would like to create the Dimension, which I can use in the apps, via Scripting.

I read that it is not possible in QlikSense. But is it possible in QlikView? To create the drilldown dimensions used in the apps / master elements via Scripting in the load Statement?

It is not about the hierarchy table for me. I have a good organized one with my Dimension - I wanto to use this to create the drilldown Dimension so that I don't have to do it manually.

Re: How to create Drill-Down Dimension via Scripting?

Tue, 02 May 2017 11:30:42 GMT

push

Re: How to create Drill-Down Dimension via Scripting?

jonathandienst — Tue, 02 May 2017 11:53:00 GMT

Please dont cross post your questions

Creating Drill-Dow-Dimension via Scripting

How to create Drill-Down Dimension via Scripting?

Re: How to create Drill-Down Dimension via Scripting?

Peter_Cammaert — Tue, 02 May 2017 11:56:45 GMT

Not in your Load Script. However, it might be possible to dynamically create Dimension Groups using macros. Check the APIguide.qvw in C:\ProgramData\QlikView Documentation\Automation.

Best,

Peter

Re: How to create Drill-Down Dimension via Scripting?

Peter_Cammaert — Tue, 02 May 2017 11:57:12 GMT

If you cannot find it there, check APIguide.qvw

Re: How to create Drill-Down Dimension via Scripting?

Tue, 02 May 2017 12:03:08 GMT

Thanks Peter for this information! Nevertheless I can't find via the first link and I'm getting an error statement with the second one. I found a pdf 'Automation Interface Reference' - maybe this helps me.

Re: How to create Drill-Down Dimension via Scripting?

Peter_Cammaert — Tue, 02 May 2017 12:11:32 GMT

Rob posted a third way to get to the APIGuide.qvw document here: Re: Where to find latest API guide

Higher up that same thread there is a posted copy of the document, but that may be an older one.

Re: How to create Drill-Down Dimension via Scripting?

Tue, 02 May 2017 14:02:20 GMT

I'm always getting the same error: 'The license that is embedded in this document is not valid'. It is just for this document 😕