Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Drilldown_group vs. cyclic_group? Confusion

Hi,

I'm working on a QlikView diagram to display data from an Excel file, easy enough. In the base data, I have a date (DD.MM.YYYY) and I add a calculated month_field in the script using Month(Datum).

Why can't I bundle these two fields (month and day) in a drilldown group? As it is, it works as a cyclic group, not the other way.

What is the reason for that?

Thanks a lot!

Best regards,

DataNibbler

13 Replies
RedSky001
Partner - Creator III
Partner - Creator III

See your attached file (okay i stripped a few things off to make it easier to see - hope you don't mind )

I created a new drill down group and added it to the chart on the right as you can see it works fine...

datanibbler
Champion
Champion
Author

Hi Mark,

can you tell exactly what finally did the trick? As far as I can see from the example, you did nothing different from what I did - only difference being that it works in the example 😉

Very curious.

Well, the issue is "solved" for now, I'm doing it differently - for reasons of easier Handling I don't work with any kind of groups, but rather with individual dimensions/ formulas each of which is active only when a variable is set to a specific value. That way, the user just has to press a button to switch between the individual/ cumulative values and the display per_day/ per_month.

Still, it would be very interesting to know why. I'm sure to come across this again.

There seem to be all sorts of things that, for no specific (apparent) reason, just don't work on my machine...

Thanks a lot!

Best regards,

DataNibbler

RedSky001
Partner - Creator III
Partner - Creator III

Hi DataNibbler,

Glad to hear it's working, to be honest I don't know what I did that was different to you, sometimes it just helps to have a second pair of eyes look over something.

Would you mind marking my last post as helpfull or correct ?

Cheers

Mark

datanibbler
Champion
Champion
Author

Hi Mark,

well, since neither you nor myself can really tell what did the trick in your instance, that isn't really helpful, but your answer was doubtlessly correct 😉

Thanks a lot for helping!

Best regards,

DataNibbler