topic Re: The data changes when Zoom-In Charts in QlikView

The data changes when Zoom-In Charts

Wed, 26 Mar 2014 15:14:17 GMT

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.

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

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!

Re: The data changes when Zoom-In Charts

semperaugustus — Wed, 26 Mar 2014 15:17:43 GMT

Hi,

how is the expression of the table?

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

Re: The data changes when Zoom-In Charts

Wed, 26 Mar 2014 15:20:07 GMT

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

ex.

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

Re: The data changes when Zoom-In Charts

ThornOfCrowns — Wed, 26 Mar 2014 15:22:04 GMT

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.

Re: The data changes when Zoom-In Charts

stevedark — Wed, 26 Mar 2014 15:27:01 GMT

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

Re: The data changes when Zoom-In Charts

Wed, 26 Mar 2014 15:28:33 GMT

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:

Re: The data changes when Zoom-In Charts

Wed, 26 Mar 2014 15:34:08 GMT

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?

Re: The data changes when Zoom-In Charts

stevedark — Wed, 26 Mar 2014 15:34:55 GMT

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

Re: The data changes when Zoom-In Charts

stevedark — Wed, 26 Mar 2014 15:36:54 GMT

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))

Re: The data changes when Zoom-In Charts

Wed, 26 Mar 2014 15:44:21 GMT

Thanks Steve, problem solved!