Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I am using 3 years data into qlikview.
How to use only one year data into Bar chart.Means "Today()-475 days.
Thanks
Gireesh
Sorry, I do not understand what you want...
Do you want a chart with a single bar?
You want to display min year or max year's data? May be with set analysis in your expression
Max Year
Sum({<Year = {$(=Max(Year))}>}Measure)
Min Year
Sum({<Year = {$(=Min(Year))}>}Measure)
According to your requirement if understand this
=Sum( {<DateField = {"$(=Date(Today()-475))"} >} Sales)
Or
=Sum( {<YearField = {"$(=Year(Today()))"} >} Sales)