0 Replies Latest reply: Oct 29, 2014 7:46 PM by SOULEIMANE BELARIBI RSS

    what's the first Step for Building Dashbord Qlikview (Join, Load, Set, If)?

      i would like to thank you for your help,

      I'm beginner on Qlikview  and i have a project to remake the same dashboard (Excel), but in Qlikview.
      For now, this dashboard (Excel) is filled from an ERP, the ERP to a SQL Server 2014 DB.
      I started doing is connect to the SQL database server and I created all dimensions 'each dimension on one tag)
      To do this I based on joins that exist in the file they gave me (see application billing.sql)

      They are the steps that I can follow Finish to create a dashboard?

      What I would do is repeat the sql query on QlikView

      CASE WHEN (D.DOC_STYPE) IN ('A', '0', 'R') THEN ELSE -L.LIG_QTE L.LIG_QTE END AS 'Qty'
      CASE WHEN (D.DOC_STYPE) IN ('A', '0', 'R') THEN - (L. [LIG_QTE] * L.LIG_POIDSN) ELSE L. [LIG_QTE] * L.LIG_POIDSN END AS 'Weight'
      CASE WHEN (D.DOC_STYPE) IN ('A', '0', 'R') THEN - (L. [LIG_FRAIS] * L.LIG_QTE) ELSE L. [LIG_FRAIS] * L.LIG_QTE END AS 'Charges1'

      Create the fact table and make the join between the different dimension.

      How to create variables and they make a call? and where?

      Attach two dimensions eg lines and Documents dimension is that it is in one of the tab I created? or it is done at the table for only?

      Is the Count, or money, aggregations are made in LOAD or SQL?
      Is my modeling is correct? I decided to make a star model.

      Attached the following files:

           DIM_LIGNES.sql: Script of the LINE dimension
           DIM_DOCUMENTS.sql: Script of the dimension DOCUMENTS
           DIMENSION_BILLING.xlsx: FILE CONTAINING THE FIELDS OF EACH DIMENSION each sheet = dimension.
           requete belling compta.txt: SQL query to create the table
           Tableau a contruire.xlsx: it is an example of the table, that I should make, the blue column is the column to be extracted from the database SQL Server. The other column in Green, it column is calculated from the blue columns

      Thank you in advance,
      PS: I speak French, if you don't understand my English