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 remakethe samedashboard (Excel),but in Qlikview. For now,thisdashboard (Excel) is filled from anERP, the ERPtoaSQL Server2014DB. I started doing isconnect totheSQL databaseserverand I createdall dimensions 'each dimension on one tag) To do thisI basedon joinsthat exist in thefilethey gave me(seeapplicationbilling.sql)
They arethe stepsthatI can followFinish to createadashboard?
What I woulddo isrepeat thesqlquery onQlikView
CASEWHEN (D.DOC_STYPE) IN ('A', '0', 'R') THEN ELSE-L.LIG_QTEL.LIG_QTEENDAS 'Qty' CASEWHEN (D.DOC_STYPE) IN ('A', '0', 'R') THEN - (L. [LIG_QTE] * L.LIG_POIDSN) ELSEL. [LIG_QTE] * L.LIG_POIDSNENDAS 'Weight' CASEWHEN (D.DOC_STYPE) IN ('A', '0', 'R') THEN - (L. [LIG_FRAIS] * L.LIG_QTE) ELSEL. [LIG_FRAIS] * L.LIG_QTEENDAS 'Charges1'
Createthe fact tableand make thejoin between thedifferentdimension.
How to createvariables andtheymakeacall? and where?
Attach twodimensionseglines andDocumentsdimensionisthatitisin one of thetabI created? orit is doneat thetablefor only?
IstheCount, or money,aggregationsare made inLOADorSQL? Ismymodelingis correct?I decided tomake astar model.
Attachedthe following files:
DIM_LIGNES.sql: Script of theLINEdimension DIM_DOCUMENTS.sql: Script of thedimensionDOCUMENTS DIMENSION_BILLING.xlsx: FILECONTAININGTHE FIELDSOF EACHDIMENSIONeach sheet=dimension. requete belling compta.txt: SQL query tocreatethe table Tableau a contruire.xlsx: it is an exampleof the table, thatI should make, theblue columnisthecolumnto be extractedfromthe databaseSQLServer.Theother columnin Green,itcolumniscalculated from thebluecolumns
Thankyou in advance, PS: I speak French, if you don't understand my English