Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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?
What use case does it not meet ?
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.
Hi why not using the qv protocol... You can connect with .net and try something like this:
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.
The answer to the question seems that it can't be done using a script, but I thank you for your suggestions.