How to display a Quarter in a chart when there is NO data for that specific quarter

[#1]

Hi,

We have a couple of charts showing trend for last 8 Quarters. Issue here is, we do not have data for some reason for one of the quarters (lets say 2011 Q3).  The chart skips 2011 Q3 on x-axis since there is not even a single transaction for this quarter and shows just 7 quarters on x-axis. Is there a way I can still show 2011 Q3 on x-axis with null transactions? I have tried removing "suppress null" property but that did not work either.

Please let me know if anyone has any suggestions.

Thanks

Subha

[Anonymous]

In chart --> presentation there is continous option just tick that option it will show all quarter

n let me knw wether it worked or not

Thnxs n Regards

Sachin Sahu

[#3]

you mean continous option in Axis tab? just tried that but got a blank

chart instead with message "No numeric values on x-axis". I guess its due

to year-Quarter dimension on x-axis. My Year Quarters is string which reads

as 2011-Q3....

On Sun, Dec 25, 2011 at 9:51 AM, Sachin Sahu <

[#4]

Hey, I just realised that it is something to do with section access. If I

remove section access, I am able to see all 8 quarters on x-axis. So, the

question now is how do I show all quarters on x-axis to all users but still

restrict data.

[#5]

Hi Subha,

I would recommend you to create master calendar ranging from min date of your transaction table upto max transaction date, You can directly link this master calendar with your transaction date but since your are using section access it will also reduce master calendar data based on given access to user. however if you keep Master calendar isolated (not connected to data model ) you can use set analysis feature to draw chart with all years/months/quarters.

Cheers.

[rohit214]

hey subha

try this

add another dimenson

add dimension

=if(len(datefield=0 OR Isnull(datefield)='-1',0,Quarter)

may it helps you

thanks rohit

[#7]

T

On Sun, Dec 25, 2011 at 12:53 PM, GM <qliktech@sgaur.hosted.jivesoftware.com