Not applicable
2014-08-05
05:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need help in the current year and previous year expression
Hello Experts,
The sales of the year 2013 is 3371 but when i select the 2014 the actual sales of 2013 is reduced to 2011, how do i display the value correctly in the chart.
I have attached a document with my query.
Thanks in advance.
- Tags:
- new_to_qlikview
239 Views
1 Reply
MK_QSL
MVP
2014-08-05
05:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=SUM({<SalesYear = {'$(=Max(SalesYear)-1)'}>}Sales)
179 Views