Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stekol61
Contributor

Problem when drilldown in graphs

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

5 Replies

Re: Problem when drilldown in graphs

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

stekol61
Contributor

Re: Problem when drilldown in graphs

Hi!

Yes. Cyclic Group  is what I have used

/Stefan

stekol61
Contributor

Re: Problem when drilldown in graphs

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

/Stefan

Re: Problem when drilldown in graphs

Why not change it to a Drill-down Group ?

stekol61
Contributor

Re: Problem when drilldown in graphs

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

Community Browser