Paint Hierarchy in Qlik Sense


Hierarchy in qlik sense: Parent_Child: LOAD EMPLOYEE_NUMBER, FULL_NAME_HEB,FULL_NAME_HEB as PATH1, MANAGER_NUMBER, MANAGER_FULL_NAME_HEB, TEAM_DESC, BussinesUnit resident t1; T2: //Hierarchy (NodeID, ParentID, NodeName, , , , , )(loadstatement Hierarchy(EMPLOYEE_NUMBER, MANAGER_NUMBER, , , ,PathName , '/' , /* TreeView*/) LOAD * Resident Parent_Child; ParentWithAllChilds: HierarchyBelongsTo ( EMPLOYEE_NUMBER, MANAGER_NUMBER, FULL_NAME_HEB, 'ParentId', 'ParentName' ) Load EMPLOYEE_NUMBER, MANAGER_NUMBER, FULL_NAME_HEB Resident T2; Qualify...
אין תגובות

SqlSaturday 2019 PowerBI


SQL Saturday 2019 take place on 11/4/2019. You are invited to my session on @PowerBI . Register Here: hashtag#SolidBIhashtag#PowerBIhashtag#PowerHerohashtag#Sql2019hashtag#Azure PowerBI hashtag#sqlsaturday
אין תגובות



Copy and paste in BAT file. Run it as ADMIN:   echo net stop QlikSenseRepositoryDatabase net stop QlikSenseEngineService net stop QlikSensePrintingService net stop QlikSenseProxyService net stop QlikSenseRepositoryService /y net stop QlikSenseSchedulerService net stop QlikSenseServiceDispatcher   echo pause echo net start QlikSenseRepositoryDatabase net start QlikSenseServiceDispatcher net start QlikSenseRepositoryService net start QlikSenseProxyService net start QlikSenseEngineService net start QlikSenseSchedulerService net start QlikSensePrintingService
אין תגובות

The Journey from Big Data to AI.


The Journey from Big Data to AI. You've got data. Now what? It’s easier than ever to make data-driven decisions with confidence. In this session, I will demonstrate how to gain actionable insights to build a competitive AI strategy. When? Monday, May 7, 2018 Where? Microsoft office, Hapnina 2 · Ra'anana Registration Link:
אין תגובות

April release of Power BI


The April release of Power BI Desktop is now available for download. The official announcement has been posted to the Power BI blog: This update contains: Reporting Q&A Explorer (preview) Buttons to trigger actions Combo chart line styles Improved default sort for visuals Numeric Slicer now generally available Analytics Update your linguistic schema New DAX function: COMBINEVALUES() Custom visuals Organizational visuals now generally available Overview by CloudScope Icon Map by Altius Hexbin Scatterplot Data connectivity Adobe Analytics connector now generally available SAP HANA connector improvement: Port selection Dynamics 365 Business Central connector Enjoy!
אין תגובות

What to expect at the Data & BI Summit


What to expect at the Data & BI Summit: Exceptional, quality content: Learn how to bring your company through the digital transformation by gaining new understandings of your data and deepening your knowledge of the Microsoft Business Intelligence tools. Products will include: Power BI, PowerApps, Flow, SQL Server, Excel, Azure, D365 and more! Answers to your questions: Network with the Microsoft Power BI team, dig-in onsite to find immediate answers with industry experts, Data MVPs, and User Group Leaders while taking advantage of the opportunity to engage in interactive sessions, workshops and labs. Network with your peers: Enjoy countless opportunities to create...
אין תגובות

Data & BI Summit

Data & BI Summit announces keynote: The Next Era of Analytics with Microsoft Power BI      
אין תגובות