Issue in drill down after exporting to excel from a pivot chart
Hello qlikview experts
I am stuck with an issue.
it will be really helpful if anyone can help me with the issue.
Here I have created a pivot chart with the gantt view added to it.
when I am exporting it to excel, it is creating the excel properly but for the columns which contains the date fields does not give a drill down while filtering the particular column in excel.
I have taken an example to be more explanatory. Following is the screenshot of excel
here above after exporting to excel, while filtering the date field no drill down has occured.
On the other hand when I am doing it with straight table it is giving the drill down while filtering for the field containing date field
As per my analysis after exporting to the excel the datatype of the values inside the date field is converting to string but not date datatype. thats why it is not giving the drill down facility in the excel.
Also, when chart it is straight table then desired result is coming but after converting the same chart to the pivot answer is coming as 1st screenshot.