Qlik Sense Syllabus

Qlik Sense Syllabus Module 1 – Qlik Sense Introduction & Installation What is QlikSense? Comparing Qlik Sense Desktop with Qlik Sense Installing Qlik Sense Desktop How Qlik Sense varies from QlikView? Starting with QlikSense Desktop Opening an app with QlikSense QlikSense Architecture Module 2 – Starting QlikSense Navigating in the user interface Data Manager Data Load Editor Data Model Viewer Interacting with the user interface … Continue reading Qlik Sense Syllabus

How to load latest month Data from Quarter QVDs SalesYYYYQ0X format

//Data load and store into QVD: Let vQVD=’Sales’&Year(Today())&num(ceil(month(Today())/3),’00’); SalesData: LOAD InvoiceNumber, InvoiceLineNumber, InvoiceDate, CustomerID, SalesmanID, ProductID, Quantity, Price, TotalPrice,’Sales’&Year(Today())&num(ceil(month(Today())/3),’00’) as QVDName FROM Data.xlsx (ooxml, embedded labels, table is Sheet2); STORE SalesData into $(vQVD).qvd(qvd); EXIT SCRIPT; //Loading latest month Data from latest QVD: Set vFolder = ‘C:\Users\SUDHIKSHA\Desktop\Qlikview\’; load * ,QvdTableName(‘Sales’&Year(Today())&num(ceil(month(Today())/3),’00’)&’.QVD’) from [$(File)] (qvd) Where month(InvoiceDate)=month(Today()); Data Download this file   Continue reading How to load latest month Data from Quarter QVDs SalesYYYYQ0X format