topic Re: Drill-Down Graphs in QlikView

Drill-Down Graphs

Fri, 03 Jan 2014 15:39:32 GMT

Hello All,

I have a drill down graph for some sales data. It starts with month, then goes to week, then goes to products sold.

The issue is I have many products, the majority of which were sold only once or twice. So when I drill down to products sold there is entirely too much data shown. Is there a way to only show products that were sold more than 25times?

For example, what I see for months is 400 units sold. Then broken down by week I see 100 units per week. Then by product per week I see 1 unit A, 1 unit B, 1 unit C, 25 unit d, 1 unit e, 30 unit f, etc. I would like to only see unit D, unit F and any other that had more than 25 units sold.

Thanks

Re: Drill-Down Graphs

swuehl — Fri, 03 Jan 2014 15:45:08 GMT

Try something like

=Sum({<Product = {"=sum(SalesCount)>=25"}>} SalesCount)

If you want to apply the condition only to the dimension Unit, you can check for the current dimension using GetCurrentField():

If(GetCurrentField( GROUP ) = 'Unit',

Sum({<Product = {"=sum(SalesCount)>=25"}>} SalesCount),

Sum(SalesCount)

)

Re: Drill-Down Graphs

Nicole-Smith — Fri, 03 Jan 2014 15:45:25 GMT

Try something like the following:

Re: Drill-Down Graphs

Fri, 03 Jan 2014 15:56:12 GMT

Thanks that is what I needed.