Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

srinivasa1
Contributor

Bar chart

Hi

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

Tags (2)
9 Replies
sivarajs
Valued Contributor II

Re: Bar chart

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

srinivasa1
Contributor

Re: Bar chart

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

Thanks

Not applicable

Re: Bar chart

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.

EK

Re: Bar chart

Hi

PFA

Regards,

R.MayilVahanan

srinivasa1
Contributor

Re: Bar chart

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

Hi

Try with

Date#()

or

timestamp()

or

timestamp#()

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

hope it helps.

srinivasa1
Contributor

Re: Bar chart

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

HI

Syntax:

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

Hope it helps

or post a sample file..

srinivasa1
Contributor

Re: Bar chart

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

Community Browser