Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Highlighted
Not applicable

How to create set analysis for drill down dimensions

I have a calendar and inventory details (Sales, Purchases). I have created the data model and now I am trying to calculate Average Inventory, which will be based on a drill down dimension of years-> Month.

Average Inventory for Year = Inventory end of Each month (1-12)/ Number of months based on the date flag (Is_MonthEnd_Flag).

But when I drill down to the year which would display all months, it should display actual inventory at the end of the month.

Any idea how this can be achieved using set analysis?

What would my expression look like?

2 Replies
vikasmahajan
Esteemed Contributor

Re: How to create set analysis for drill down dimensions

I think requirement is not clear  can you create some dummy qvw and post as per your data ?  to get solution

Vikas

Re: How to create set analysis for drill down dimensions

I agree with Vikas, a sample will help us understand the requirement better. Please don't forget to mention the required output