Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator III
Creator III

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

Labels (1)
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
MVP
MVP

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
Champion III
Champion III

According to your requirement if understand this


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

Or

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