Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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
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
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