QlikView displays the data of the year before the selected time.
The customer often asks for this. When the user selects a time, the data of the year before the selected time is displayed in the chart. The following is my method. If there is any improper method, please advise:
Data preparation is as follows:
SalesData:LOADNum(ID) as ID,Date(Date) as Date,Month,Num(Year) as Year,Num(Sales) as SalesInline [ID, Date, Month, Year, Sales1, 2012-1-1, 2012-1, 2012, 202, 2012-1-1, 2012-2, 2012, 213, 2012-1-1, 2012-3, 2012, 234, 2013-1-1, 2013-1, 2013, 345, 2013-2-1, 2013-2, 2013, 356, 2013-3-1, 2013-3, 2013, 467, 2014-1-1, 2014-1, 2014, 278, 2014-2-1, 2014-2, 2014, 309, 2014-3-1, 2014-3, 2014, 49];
Create a chart:
Use Month as the dimension ,:
Create an Expression in the Expression tab as follows:
The Sales expression is as follows:
=Sum({$<Date={'>$(=Date(Max(Date)-365))<=$(=Date(Max(Date)))'}>}Sales)
Click "OK" and create a new Date list, as shown in. If no Date is selected, the Sales chart displays the data of the past year by default:
If you select a time, the Sales chart displays the data of the year before the selected date, as shown in. Because you select 2014-1-1 1, the Sale chart displays the data of the year before the 2014-1-1 1.
Conclusion: The Sales expression above proves that "> =", "<=" can be implemented in QlikView ". If you have any questions, please leave a message!
QlikView Problems
Use WorkBranch for development ~~ It is also an artifact of QLIKTEACH.
What is qlikview used?
QlikView is a complete business analysis software that enables developers and analysts to build and deploy powerful analysis applications. The QlikView application enables various end users to interact and analyze important business information in a highly visual, powerful, and creative manner.
QlikView puts the three factors required for business analysis in an independent software package. QlikView customers can get:
A wizard-driven Application Development Environment with fully integrated ETL tools, a powerful AQL analysis engine with unlimited drilling in mind, a highly intuitive, the simple user interface QlikView enables developers to extract and cleanse data from a variety of databases and build powerful and efficient applications, they can also be modified and used by power users, mobile users, and end users on a daily basis. QlikView's patented AQL architecture leverages increased computer and network devices, such as low-cost and fast memory. When providing flexible and powerful analysis capabilities, the AQL architecture changes the need for OLAP cubes and does not have to use databases. QlikView is an upgradeable solution that fully utilizes the basic hardware platform to use hundreds of millions of data records for business analysis. QlikView consists of the following components: QlikView Local Client, QlikView Server, QlikView Publisher, and SAP \ Salesforce \ Informatica ). The server supports multiple publishing methods, such as AJAX clients and ActiveX clients. It can also be integrated with other CS/BS systems.
Therefore, QlikView can be quickly deployed as a powerful analysis tool.