topic Re: Problem when drilldown in graphs in QlikView

Problem when drilldown in graphs

stekol61 — Tue, 22 Mar 2016 13:35:38 GMT

Hi!

I want my report to work as follows.

- When the report is opened and reloaded it should show data for today and the previews 6 days in a graph

- It should also be possible to manually select the date range you are interested of.

- it should be possible to drilldown in a graph between Hour-Day-Week-Month

The drilldown works OK if I manually select the date range but not if look at previous 6 days..

I added a button in order to make drilldown work but I prefer to not use a button and instead always be able to drilldown.

See enclosed qvw

/Stefan

Anonymous — Tue, 22 Mar 2016 14:27:54 GMT

Did you mean to use a Cyclic Group as opposed to a Drill-down Group ?

stekol61 — Tue, 22 Mar 2016 14:46:29 GMT

Hi!

Yes. Cyclic Group is what I have used

/Stefan

stekol61 — Tue, 22 Mar 2016 14:59:41 GMT

Hi again!Maybe there is a better way to do this

/Stefan

Anonymous — Tue, 22 Mar 2016 15:28:37 GMT

Why not change it to a Drill-down Group ?

stekol61 — Wed, 23 Mar 2016 09:13:54 GMT

Hi!

I have used this expression to get the previos n days (v.Previous) as default.

I also have a button that disables the formula (v.Dril).

What I would nee is a way to avoid the v.Dril button and still be able to drill down both for default 6 days and manually selected dat range.

if (v.Drill='1' , sum({<Date={">=$(=AddMonths(Max(Date-v.Previous),0))<=$(=Max(Date))"}>} RecordsIn) , sum(RecordsIn))

/Stefan