Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

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
Anonymous
Not applicable

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

stekol61
Creator
Creator
Author

Hi!

Yes. Cyclic Group  is what I have used

/Stefan

stekol61
Creator
Creator
Author

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

/Stefan

Anonymous
Not applicable

Why not change it to a Drill-down Group ?

stekol61
Creator
Creator
Author

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