show zero values in bargraph

[Anonymous]

I need to show present quarter and  previous 3 quarters always even when if there is no data for quarters(just as axis)... I created master calender such that it can have all dates, months and quarters  and i can not clik to show all values in dimension tab because i have to show only 4 quarters.... by result,this is not showing me the quarters which do not have data..

can some one help me...

Please find attachment here...

Thanks

[MayilVahanan]

HI

Try like this

Properties -> Presentation -> Uncheck suppress Zero-Values and check Zero on Bars.

Hope tat helps

If not, please attach sample

[Anonymous]

Hi

I did that but no use... please find sample here...

[#4]

see the attached .qvw file...
Just as Mayil said..
it can be done by unchecking the "supress zero values" in the Presentation tab..

[er_mohit]

See the attached file

[Anonymous]

I have to show only 4 bars in barchart, not the complete data which has zeros, have to show intermediate bars which has zeros(just as axis)on bar chart, this is what creating me a problem... any time only 4 bars showing 4 quarters. please find sample above...

[Anonymous]

Hi

I tried to uncheck the "Supresss zero values " which shows all the quarters even which has zeros and limit dimension by writing below expression

Aggr(only({<YearQuarter_CP ={'<=max(YearQuarter_CP)' and '>=max((YearQuarter_CP)-3)' }>}[YearQuarter_CP]),[YearQuarter_CP])

can some one correct me with the expression..

Thanks,

Praveena

[tresesco]

Try like:

Aggr(only({<YearQuarter_CP ={'>=max((YearQuarter_CP)-3)' }>}[YearQuarter_CP]),[YearQuarter_CP])

[Anonymous]

It is only giving single stacked bar on bar chart...with out 4(quarters) bars on bar chart.. is it only way to limit dimension?

[tresesco]

This is because your YearQuarter_CP field is a string field. No numeric function(e.g-max()) / operation can be done on it.