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!
Solved! Go to Solution.
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 ?
thanks for helping!
I don't see the difference between your example and what I've done - well, yes, you have a formula for the month in the group itself whereas I have the formula in the script already. But it doesn't work yet. Have I overlooked something?
I can create a drilldown group, but then I'm stuck with the dimension >month<, the >day< never appears.
When I change it into a cyclic_group, it works fine.
I have a date in the original base data. In the script, I have created a month_field. That's all there is.
I've also just tried doing that calculation (IF...>=Monthstart(TODAY()) in the script, but that doesn't change things.
Are you able to upload a small example file? It shouldn't make a difference if you convert the date in the script or UI, I was just being lazy in fact as the script is the best place.
in principle I can. The issue is, everything I'm dealing with is actually sensitive information. I'll see what I can do.
You're right, whenever a formula can be inserted in the UI or the script, the script is the place to prefer.
Talk to you,
Well, I guess there's no other way - creating a dummy file now will cost me too much time. I will just trust to your not misusing this data.
When I try and open it it starts doing a reload and because I don't have access to your sources files only some data is on the dashboard.
"Cannot open file '\\rgb1app202\production\99_Resources\Qualitaet\QS KPI 2013.xlsx' The network path was not found."
Can you upload it without the automatic reload?
third attempt - I adjusted the file_path and I removed the trigger for automatic reload. Now it should work if you place that Excel file and the qvw file in the same directory.
Thanks a lot!
Have a nice weekend!