Script to create drill-down group?

[#1]

I have a table that includes the columns CountryName, StateName and CityName.

I want to create a drill-down group using these columns, such as CountryName->StateName->CityName.

I can do this manually in Qlik Sense, by creating a drill-down dimension in the Master Items tab and clicking the columns that I want in the hierarchy.

Can I do it in a script?

[Anonymous]

The way you have already done it "by creating a drill-down dimension in the Master Items tab and clicking the columns that I want in the hierarchy"  is the best way to do it.

[#3]

Bill, thank you for your reply, but I'm trying to script a model including drill-down groups.

Doing it manually might be the best way - it certainly is easy - but it doesn't meet my use case.

Can I write a script to do it?

[Anonymous]

What use case does it not meet ?

[#5]

I've got to translate a cube with hundreds of hierarchies from another platform. I've scripted the model, and if I can script the drill-downs as well I'll save a lot of tedious clicking and checking.

[arthur_dom]

Hi why not using the qv protocol... You can connect with .net and try something like this:

https://help.qlik.com/sense/2.0/en-us/developer/#../Subsystems/Workbench/Content/MashupEditor/mashup...

[phaneendra_kunc]

I don't think there is a script way of doing this at least in Sense. But there are ways doing it in Qlikview using "VB-Macros".

Again wondering how many Drill groups are we talking here? I hear 100's, don't you think user will be over whelmed with that many Drills?

Drill groups are manual creation in sense at this moment. I haven't seen any API to automate the creation at this moment.

[#8]

The answer to the question seems that it can't be done using a script, but I thank you for your suggestions.