topic Drill Down in QlikView

Drill Down

s2016 — Wed, 25 Nov 2020 16:16:04 GMT

I have a "weekly" dataset in QV.

Using this dataset, I need to create "Monthly" charts on the front end by aggregating the numbers and also need capability for the user to drill down to "weekly" data in a chart to do more analysis. Just wondering what are the different ways to do this.

Re: Drill Down

kaushiknsolanki — Thu, 15 Jun 2017 07:15:31 GMT

Hi,

You can create a Month from the Week you have(Hoping you have a WeekStart Date) in your data set.

Once you create a month, you can create a drill down dimension to allow users to drill from month to week.

Regards,

Kaushik Solanki

Re: Drill Down

ahaahaaha — Thu, 15 Jun 2017 07:17:31 GMT

Hi,

Too broad a formulation of the problem. Can be done if not all, then very much. Everything depends on goals and objectives.

Regards,

Andrey