topic Drill down group not working with threshold in QlikView

Drill down group not working with threshold

Fri, 27 Jan 2012 20:24:48 GMT

I have a small table with the following columns

Class (dimension)

Billing $ (measure)

I want the Class column to be able to drill down to Advertiser so I created a drill down group called 'Class>Advertiser. I also have an input box for a threshold (called vTreshHoldSize) value where users will want see any Billing $ above this threshold. However, it looks like when I apply the threshold to my expression in the Billing $ column the drill down DOES NOT WORK. So I am trying to see if I can apply the drill down value to my expression but I can not seem to get it working. Or maybe there is an easier way to do this so I can BOTH have a threshold and the drilldown working?? See below expression...

=if(vYearIndicator='Current',

if($(CurrentBilling)>= vTreshHoldSize and getcurrentfield([Class>Advertiser])='Class',Aggr($(CurrentBilling), Class)),

if($(CurrentBilling)>= vTreshHoldSize and getcurrentfield([Class>Advertiser])='Advertiser',Aggr($(CurrentBilling), Advertiser))

//=$(CurrentBilling)

)

Drill down group not working with threshold

Sat, 28 Jan 2012 03:25:29 GMT

Could you send an example?

Re: Drill down group not working with threshold

Sun, 29 Jan 2012 18:09:30 GMT

Hi,

It works as see in attached example file.

While I don't know your exact scenario but I believe you are making it overly complex. You don't need to use aggr because just using sum should work fine in your case or may be I am missing some thing.

Hope it helps!

...

Ashutosh

Drill down group not working with threshold

Mon, 30 Jan 2012 14:35:30 GMT

This is almost exactly what I need but 'B' is an expression NOT a dimension. You have it as a dimension. I can not get your example working when 'B' is an expression.

Drill down group not working with threshold

Tue, 31 Jan 2012 05:20:37 GMT

Hi,

I have also taken B as an expression, or maybe I don't get what you are referring!

Can you just explain it a bit by an example. So, I will be in a better position to help.

Ashutosh

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 15:43:10 GMT

Sorry for the confusion. I have attached a small QV app (version 10 SR4) where I am trying to apply a threshold to Sales amounts. Meaning, I want to display Sales above the threshold amount entered in the input box. But also keep the dimensionality of the drill down. You can see LineSalesAmount is an expression.

I hope this helps.

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 16:09:02 GMT

Hi Melinda,

Do you want to apply that threshold only to the Sales amount of category, if it is then have a look at the attached application or if still I have not got it then I feel you will again need to explain me.

Please find the attached application.

...

Ashutosh

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 16:37:28 GMT

Hi Melinda,

Sorry there is a little modification in the chart.

Please find the updated application attached.

Thanks

Ashutosh

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 18:48:07 GMT

Hi Ashutosh,

Thank you so much for the quick response and helping me out with this issue. This is almost what we need however, we will need to apply the threshold to every level of dimensions (CategoryName>ProductName>Shippers) not just category name. Also, is there are way to apply the threshold to the sales amount to a dimension that is not in the chart? I hope this is clear.

Melinda

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 19:18:02 GMT

ok thwn in that case, the 3rd chart (placed below) should perfectly work for you.

yes, you can use the dimensions which are not in chart also.

Thanks

Ashutosh

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 19:21:22 GMT

3rd chart? Sorry, I do not see 3rd chart. Is there supppose to be an attachment in your last post?

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 19:24:20 GMT

Actually, It is the second chart which I made.

Chart titled Sales in the Item > threshold

Do you see it? It is in the same application only.

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 19:29:02 GMT

I see it but the drilldown does not work.

Re: Drill down group not working with threshold

Thu, 02 Feb 2012 19:32:00 GMT

It works for me!

May be you need to change the threshold to some lower value, say 100 and then drill down, you will see values.

Drill down group not working with threshold

Fri, 03 Feb 2012 18:00:47 GMT

Ashutosh,

Thank you so much for helping me with this issue. Although, we are working with some rather complicated expressions in our actual QV app, I was able apply your small expression example to the complex expressions we are using across our application.

Much appreciated! Cheers!

Melinda

Re: Drill down group not working with threshold

Fri, 03 Feb 2012 18:10:58 GMT

Thanks, Melinda,

Seeing fellow Qlikers happy is the biggest motivation for me.

...

Best Regards

Ashutosh

Drill down group not working with threshold

Tue, 28 Feb 2012 16:03:56 GMT

Ashutosh,

I was wondering if you can help me with another problem dealing with the threshold inputbox and drilldown. Is there a way to clear the threshold inputbox or set it to zero when a user drills down or when a user clicks to drilldown in the table?