Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

Display one year data into charts

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

3 Replies
MarcoARaymundo
Creator III
Creator III

Sorry, I do not understand what you want...

Do you want a chart with a single bar?

sunny_talwar

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)

its_anandrjs

According to your requirement if understand this


=Sum( {<DateField = {"$(=Date(Today()-475))"}  >} Sales)

Or

=Sum( {<YearField = {"$(=Year(Today()))"}  >} Sales)