How to Optimize Group By Performance in Qlikview?

For example, we have ID,Sales data is there in a table. It will take too long to use group by function directly. So,first we should sort the table on ID and then use. Table: LOAD ID, Sales from Table; NoConcatenate Table_Sort: Load ID,Sales Resident Table Order by ID; Table _Group: NoConcatenate Load ID,Sum(Sales) Resident Table_Sort Group By Table_Sort; Drop table Table,Table_Sort; Continue reading How to Optimize Group By Performance in Qlikview?

Microsoft Power BI Learning Continue reading Microsoft Power BI Learning

Master Calendar – Michael Torallo

QuartersMap: MAPPING LOAD rowno() as Month, ‘Q’ & Ceil (rowno()/3) as Quarter AUTOGENERATE (12); Temp: Load min(OrderDate) as minDate, max(OrderDate) as maxDate Resident Orders; Let varMinDate = Num(Peek(‘minDate’, 0, ‘Temp’)); Let varMaxDate = Num(Peek(‘maxDate’, 0, ‘Temp’)); DROP Table Temp; TempCalendar: LOAD $(varMinDate) + Iterno()-1 As Num, Date($(varMinDate) + IterNo() – 1) as TempDate AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate); MasterCalendar: Load TempDate … Continue reading Master Calendar – Michael Torallo