Solved: Drill Down - Qlik Community

s2016 · ‎2017-06-15

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.

kaushiknsolanki · ‎2017-06-15

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2017-06-15

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

ahaahaaha · ‎2017-06-15

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

Drill Down

Related Topics