topic show zero values in bargraph in QlikView

show zero values in bargraph

Anonymous — Tue, 22 Oct 2013 21:21:28 GMT

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

Re: show zero values in bargraph

MayilVahanan — Tue, 22 Oct 2013 21:24:33 GMT

Try like this

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

Hope tat helps

If not, please attach sample

Re: show zero values in bargraph

Anonymous — Tue, 22 Oct 2013 23:36:02 GMT

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

Re: Re: show zero values in bargraph

Wed, 23 Oct 2013 05:20:04 GMT

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

Re: show zero values in bargraph

er_mohit — Wed, 23 Oct 2013 05:27:12 GMT

See the attached file

Re: show zero values in bargraph

Anonymous — Wed, 23 Oct 2013 15:17:22 GMT

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

Re: show zero values in bargraph

Anonymous — Thu, 24 Oct 2013 13:37:25 GMT

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

Re: show zero values in bargraph

tresB — Thu, 24 Oct 2013 13:40:51 GMT

Try like:

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

Re: show zero values in bargraph

Anonymous — Thu, 24 Oct 2013 13:48:37 GMT

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?

Re: show zero values in bargraph

tresB — Thu, 24 Oct 2013 14:30:52 GMT

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

Re: show zero values in bargraph

Anonymous — Thu, 24 Oct 2013 14:34:52 GMT

oh !! I got you, so, is there a way to limit dimension which is not numeric.. which can limit to current selection and previous 3 ...??

Re: show zero values in bargraph

tresB — Thu, 24 Oct 2013 14:46:02 GMT

I guess you should try otherwise, use the limiting time set analysis part in the expression(NOT calculated dimension) itself and let the dimension remain simple field value. Based on your expression limit dimension would get reduced. And yes, you can limit the string quarters based on your numeric date field.

Ex:

=Aggr(only({<Date_CP ={'>=$(=num(Addmonths(Max(Date_CP),-9)))' }>}[YearQuarter_CP]),[YearQuarter_CP])

I would suggest not to use calculated dimension here. Instead use SET part something like :

{<Date_CP ={'>=$(=num(Addmonths(Max(Date_CP),-9)))' }>} in your main expression.

Re: show zero values in bargraph

Anonymous — Thu, 24 Oct 2013 15:35:32 GMT

Ya, we can do it by date, I used YearQuarter in dimension as it is, Date in expression to limit Quarters,but it is showing no change as before; see below

Count(Distinct {[State_PP]< Year_CP = , Month_CP = , Quarter_CP = ,Date_CP ={'>=$(=num(Addmonths(Max(Date_CP),-12)))'},

MonthN_CP = {'$(=$(vGetMonthYear(vSelectedDate)))',

'$(=$(vGetMonthYear(Date(QuarterStart(vSelectedDate) - 1))))',

'$(=$(vGetMonthYear((QuarterStart((QuarterStart(vSelectedDate)-1))-1))))',

'$(=$(vGetMonthYear((QuarterStart((QuarterStart((QuarterStart(vSelectedDate) - 1)) - 1)) - 1))))'

}>} [Patient ID])

Correct me if I am wrong..