Animated Grid Chart

[#1]

Hi, I need some help..

I want to make a grid chart and animate it.

Date is my first dimension, animation rotates on date dimension.

I dont want to show the years before 2006 because data is not reliable so much.

How can I restrict the date value, and start from 2007??

Thanks ..

[sparur · Accepted solution]

Hello,

you can use Set Analysis in your expression:

sum({<Year = {">2006"}>} Amount)

or

you can use calculated dimension:

IF (Year > 2006, Year)

and then check option "Suppress when value is null" in Dimension Tab

the first approach is more preffered

[#3]

Thanks, your answer is really helpful.

The first solution is more suitable for my case.

I already used the if condition but null values were presented too.

But when I checked the option "Suppress when value is null" , the problem is solved.

[#4]

Hi, I have one more question..

Altough I try to show values for one quarter of a year, the values for many quarters are shown as pop - up text on my animated chart.

I want to show each quarter at one frame

The property window is set as shown

[#5]

Hi there !

Are there any suggestions??

[sparur]

Hello, may be try to create custom popup labels? Can you post your qvw file, I'll try it

[#7]

I tried to add custom pop up label but then both of them are presented.

[#8]

Why does it show all the date values, I could not understand.

Please help, what is wrong with that..