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

The data changes when Zoom-In Charts

Hi all, have you noticed this: when you use the mouse and try to zoom in in a chart, the data shown on the chart will change. How to keep the data fixed even when you zoom-in?

Example: this is the original chart.

2014-03-26_1110.png

when I zoom-in to "10-16 days": the chart will become:

2014-03-26_1112.png

Notice the date all changed to 100%. This is not what we want.

How can I keep the data fixed when I zoom-in and zoom-out?

Thanks!

1 Solution

Accepted Solutions
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

It should sit just after the sum statement:

sum({1} if(fiscal = $(vLastFY-3) and [deposit_date] <=

  makedate(year(today())-4, month(date(today())), day(date(today()))), Net_Bookings))

View solution in original post

9 Replies
semperaugustus
Partner - Contributor II
Partner - Contributor II

Hi,

how is the expression of the table?

can you post the value of the current selection before and after the zoom?

Not applicable
Author

Add in your set analysis of the expression of the cart this filter:

ex.

...sum({<...,tour_lenght={"*"}>Value}...

ThornOfCrowns
Specialist II
Specialist II

You'er not 'zooming in' per se, you're filtering the chart, whcih is showing just one set of data. That set is 100% of the new total.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I presume your expression is something like:

sum(Value) / sum(TOTAL Value)

Total in this case is the Total of the currently selected values.  You want to ignore selections for this field, so the expression would become:

sum(Value) / sum({1}TOTAL Value)


The {1} is Set Analysis syntax for 'ignore all selections'.  If you want to keep the impact of some selections, but ignore others (eg. only ignore tour_length selections) you would require something like:


sum(Value) / sum({<tour_length=>}TOTAL Value)


If there are multiple fields you need to ignore you need to comma separate them:


sum(Value) / sum({<tour_length=,OtherFeld1=,OtherField2=>}TOTAL Value)


Hopefully that will put you on the right track...


Steve

Not applicable
Author

Hi Diego,

The expression:

     there are 6 expressions, 1 for each year, the expression looks like:

          sum(if([deposit_date] <=

            makedate(year(today())-1, month(date(today())), day(date(today())))

            and fiscal = vCurrentFY, Net_Bookings)

          )/vCurrentFY_NetBooking_YTD_FutureFY

current selection:

2014-03-26_1127.png

Not applicable
Author

Hi Steve, this is inspiring,

my expression is

sum(

if(date([deposit_date]) <=

  makedate(year(today())-5, month(today()), day(today()))

  and fiscal = $(vLastFY-3), Net_Bookings)

)/$(vLastFY_3_NetBooking_YTD_FutureFY)

and the vLastFY_3_NetBooking_YTD_FutureFY is dynamic variable :

sum(if(fiscal = $(vLastFY-3) and [deposit_date] <=

  makedate(year(today())-4, month(date(today())), day(date(today()))), Net_Bookings))

How should I use {1} here?

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Xuan,

It looks like it is the vCurrentFY_NetBooking_YTD_FutureFY variable that needs the Set Analysis code to ignore selections added in.

Steve

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

It should sit just after the sum statement:

sum({1} if(fiscal = $(vLastFY-3) and [deposit_date] <=

  makedate(year(today())-4, month(date(today())), day(date(today()))), Net_Bookings))

Not applicable
Author

Thanks Steve, problem solved!