Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

How to create Drill-Down Dimension via Scripting?

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!

9 Replies
vinieme12
Esteemed Contributor II

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

Not applicable

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

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.

Not applicable

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

push

MVP
MVP

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

Please dont cross post your questions

Creating Drill-Dow-Dimension via Scripting

How to create Drill-Down Dimension via Scripting?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

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

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?

If you cannot find it there, check APIguide.qvw

Not applicable

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

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?

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.

Highlighted
Not applicable

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

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