topic Animated Grid Chart in QlikView

Animated Grid Chart

Tue, 22 Jun 2010 12:29:51 GMT

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 — Tue, 22 Jun 2010 12:34:15 GMT

Hello,

you can use Set Analysis in your expression:

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

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

Tue, 22 Jun 2010 12:43:24 GMT

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.

Tue, 22 Jun 2010 15:57:38 GMT

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

Wed, 23 Jun 2010 07:06:51 GMT

Hi there !

Are there any suggestions??

sparur — Wed, 23 Jun 2010 07:11:33 GMT

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

Wed, 23 Jun 2010 08:16:24 GMT

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

Wed, 23 Jun 2010 09:05:58 GMT

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

Please help, what is wrong with that..