//How to load latest file from the folder For Each File In Filelist (‘C:\Myfolder\*.*’) Folder: Load ‘$(File)’ As Name, Filetime( ‘$(File)’ ) As Filetime Autogenerate 1; Next File Latestfile: First 1 Load Name, Filetime, 1 As Dummy Resident Folder Order By Filetime Desc; Drop Table Folder; Advertisements Continue reading How to load latest file from the folder?
Example on Mixed granularity – Budget vs Actuals Source: Henric Cronström // ============== Products ============== ProductCategories: LOAD ProductCategoryID, ProductCategory, Description FROM ProductCategories.qvd (qvd); Products: LOAD // ProductCategoryID, ProductID, ProductName, UnitCost, ListPrice, UnitsInStock, UnitsOnOrder FROM Products.qvd (qvd); MapProductIDToProductCategoryID: Mapping Load ProductID, ProductCategoryID FROM Products.qvd (qvd); [Products link table]: Load distinct ProductCategoryID & ‘|’ & ProductID as %ProductID, ProductCategoryID, ProductID FROM Products.qvd (qvd); Load distinct ProductCategoryID & ‘|’ … Continue reading Example on Mixed granularity – Budget vs Actuals – HIC
topsellingProducts: LOAD Products,Amount INLINE [Products,Amount Product1,1200 Product2,1500 Product3,1200 Product4,1400 Product5,1400 Product6,1500 ]; How to show Top Product Names in a text box? =concat( aggr(if(rank(sum(Amount)) <= 1, Products), Products), chr(10), aggr(rank( sum(Amount) ), Products ) ) Continue reading How to show Top Product Names in a text box?
estimate_number,est_rev_nbr,description,amount 307,0,Hotel,500 307,1,Hotel,1000 307,2,Hotel,1500 307,0,Flight,200 307,1,Flight,300 307,2,Flight,400 307,3,Flight,500 How to show Hotel (1500) and Flight (500) values? Solution: Sum(Aggr(FirstSortedValue(amount, -est_rev_nbr), description)) Continue reading Aggregation with FirstSortedValue
1.Implemented QIX engine to this version. Seemless upgrade from QV11 to QV12. 2.Intigraded the Qlik Data Market 3.Added RESTful API connector. We can easily connect to Facebook,Twitter,LinkedIn. 4.Better mobile experience. Change object properties Create objects right click menu Move, copy or resize objects New menu for additional options Send to Excel via mobile device Swiping to scroll 5.Improved security in better encryption, better client request … Continue reading What’s new in QlikView 12
QlikView server crashing,User sessions multiplying. Windows server 2012, 64 Go RAM, 2.19 GHz, 4 Core Sometimes the server is slowing down and then worse, no user could load any application on their screen (the screen stays white, it’s not the “session lost” error). The RAM & CPU usage on the server increased exponentially (QVS.exe service). Solution: Delete all server objects/bookmarks in QMC. It is a … Continue reading Qlikview 12 bug
3 Tier architecture example Continue reading 3 Tier architecture example