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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis help

Hi,

I have a requirement to show a bar chart for year wise sum of amounts. For this I have created a bar chart with 'Year' as dimension and 'Sum(Value') as expression. This is working fine.

But my requirement is, in each bar where it is showing data for that year I want to show data for >= that year. Means bar for 2010 should show sum of all values where year >= 2010 instead of year = 2010. The same should happen for 2011 bar and etc..

COuld you please help me with an set analysis expression to achieve this.

Sample qvw attached with this post.

Regards,

Murali

11 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Check the attached file hope this suits better for your requirement.

Regards,

Jagan.

Not applicable
Author

Its working perfectly. Thanks a lot.