topic Re: Bar chart in QlikView

Bar chart

srinivasa1 — Tue, 20 Nov 2012 01:20:28 GMT

I would like to display all date in bar chart ( showing in arrow mark 10/12/2012 and other date is missing in bar chart. i need to display all date )

I have attached sample application for eassy refrence. can any suggest me how can do this

Thanks in advance

Re: Bar chart

sivarajs — Tue, 20 Nov 2012 04:07:11 GMT

Those dates doesnt have the amount in it

So that its not displaying but if you want display zero value, goto presentation tab and uncheck supress zero value

Re: Bar chart

srinivasa1 — Tue, 20 Nov 2012 15:07:40 GMT

Thanks for Quick reply i would like to shows 0 in bar if sum(Amount)=0
can you pls guide me

Thanks

Re: Bar chart

Tue, 20 Nov 2012 15:16:31 GMT

In presentation tab click on the "Zero on Bars" radio button. This is below the unchecked "Suppress Zero Values". In the Expressions tab click on the "Values on Data Points". That should show zero where there are no bars.

Re: Bar chart

MayilVahanan — Tue, 20 Nov 2012 15:16:59 GMT

PFA

Regards,

R.MayilVahanan

Re: Bar chart

srinivasa1 — Tue, 20 Nov 2012 17:09:06 GMT

Thanks

Its usefull but my date with time also when im trying format to Date([date]'MM/DD/YY')
it will not show a date

Thanks

Re: Bar chart

MayilVahanan — Tue, 20 Nov 2012 17:15:59 GMT

Try with

Date#()

timestamp()

timestamp#()

because, may be its not correct format for date field..

hope it helps.

Re: Bar chart

srinivasa1 — Tue, 20 Nov 2012 18:14:40 GMT

Thanks its not working im whenever getting null value like "-"(is null (represnted by "-")) it will not disply date in bar

Appreciate your help

Re: Bar chart

MayilVahanan — Tue, 20 Nov 2012 18:28:49 GMT

Syntax:

Date([date], 'MM/DD/YY')

Hope it helps

or post a sample file..

Re: Bar chart

srinivasa1 — Wed, 21 Nov 2012 01:29:28 GMT

Hi Thanks for your help.

Your right but there's pbm in my data as its comes in null one more dim.i have found that some other way to handle this and its working .done format in etl like dateisland thanks