topic Re: Drill-down in Dimensional Limits in QlikView

Drill-down in Dimensional Limits

Thu, 09 May 2013 21:55:03 GMT

I am making a bar chart showing expenses every month. On the first level I want to show all 12 months chronologically and against total expense. At the drilldown, I only want to show the top 3 types of expenses for that month. Dimensional limits either lets me show all 12 but then shows 12 expenses, or shows the top 3 months and then the top 3 expenses.

Is there a way to separate the drilldown dimensional limit from the first level dimension?

I really appreciate any thoughts!

Re: Drill-down in Dimensional Limits

rustyfishbones — Thu, 09 May 2013 23:01:36 GMT

Try using the RANK() function in the Dimensional limits

Re: Drill-down in Dimensional Limits

Fri, 10 May 2013 13:09:45 GMT

Hi Alan,

I see the checkbox that says "Restrict to 3 Largest" but would get me back to the problem of only showing 3 months and 3 expenses. Is there a way to write a rank function into the dimensional limits while restricting the values to 12 so that all the months are shown? Thanks!

Re: Drill-down in Dimensional Limits

rustyfishbones — Fri, 10 May 2013 14:52:45 GMT

Is it possible to send me a copy of the file, I will try figure it out in the meantime

Re: Drill-down in Dimensional Limits

Fri, 10 May 2013 15:19:15 GMT

I'm unfortunately not able to post the full file (confidential info! ). Let me give a concrete example below:

Monthly expenses are as follows:

Jan 1000

Feb 2000

March 1500

April 1400

May 2500

June 2400

July 1575

Aug 2100

Sept 1300

Oct 1900

Nov 1800

Dec 2010

If I drill down into January, I find that there are 20 expense categories that sum up to $1000 (rent, electrical, operations, IT support, labor, etc)

The top three expenses are

Rent - $400

Legal - $175

IT - $100

Would I be able to create a bar chart that shows all the months with total expenses, and then a drill down into Jan that would just show four bars - Rent, Legal, IT, and Other ($325)?

Please let me know if that's clear. Thank you!

Re: Drill-down in Dimensional Limits

rustyfishbones — Fri, 10 May 2013 15:31:47 GMT

Hi,

I understand not what you are trying to achieve, let me try figure if it can be done

Regards

Alan

Re: Drill-down in Dimensional Limits

prabhuappu — Wed, 19 Jun 2013 17:33:45 GMT

Hi,

use the following expression in the dimensions limit value,

=if(GetCurrentField(Group_Name)='expense categories',4,12)

Group_Name is drill down group name.

Regards,

Prabhu