Discussion Board for collaboration on QlikView Layout & Visualizations.
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
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
Thanks for Quick reply i would like to shows 0 in bar if sum(Amount)=0 can you pls guide me
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.
Its usefull but my date with time also when im trying format to Date([date]'MM/DD/YY')it will not show a date
because, may be its not correct format for date field..
hope it helps.
Thanks its not working im whenever getting null value like "-"(is null (represnted by "-")) it will not disply date in bar
Appreciate your help
Hope it helps
or post a sample file..
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