topic Re: Hi in QlikView

topic Re: Hi in QlikView https://community.qlik.com/t5/QlikView/Hi/m-p/765323#M1041858 <HTML><HEAD></HEAD><BODY><P>Hello Madhu,</P><P></P><P>Glad to help where I can, but please be more specific in your request. Now it looks like an exam question...</P><P></P><P>Regards,</P><P></P><P>johan</P></BODY></HTML> Wed, 03 Dec 2014 08:52:03 GMT puttemans 2014-12-03T08:52:03Z Hi https://community.qlik.com/t5/QlikView/Hi/m-p/765322#M1041857 <HTML><HEAD></HEAD><BODY><H4><SPAN style="font-size: 10pt;">please see below attachments i want to</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">The data model should associate the following tables:</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">Trades – FACT table</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">Products – links to trade using PRODUCTCLASSID</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">Desk – links to trade using SALESDESKID</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">Exchange – links to Trade using EXCHANGEID</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">Sector – links to Trade using SectorID</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;"><STRONG>DIMENSIONS</STRONG>     All the dimensions such as client account, client, product, region , date etc are easily identifiable</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;"><STRONG>MEASURES         </STRONG>You must make a minimum of 5 KPI’s based on your understanding of the data. Excluding the</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">                                COUNT(ID)                                         Number of transactions</SPAN></H4><H4 class="yiv8992448561MsoNormal" style="color: #000000; font-size: 11pt; font-family: Calibri, sans-serif;"><SPAN style="font-size: 10pt;">                                SUM(TRADE REVENUE)                 Total Revenue  </SPAN></H4><H4 style="color: #000000; font-family: arial, sans-serif; font-size: 13px;"><SPAN style="font-size: 10pt;">    should be able to see the number of transactions per sales desk in a map. (Add your own coordinates)</SPAN></H4><H4 style="color: #000000; font-family: arial, sans-serif; font-size: 13px;"><SPAN style="font-size: 10pt;">    Month to Date versus Last Year Month to Date, Month to Date versus Last Month to Date and variance</SPAN></H4><H4 style="color: #000000; font-family: arial, sans-serif; font-size: 13px;"><SPAN style="font-size: 10pt;"><SPAN style="color: #1f497d;">    </SPAN>This Year to Date versus Last Year to Date and variance.</SPAN></H4></BODY></HTML> Wed, 03 Dec 2014 08:29:04 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/765322#M1041857 2014-12-03T08:29:04Z Re: Hi https://community.qlik.com/t5/QlikView/Hi/m-p/765323#M1041858 <HTML><HEAD></HEAD><BODY><P>Hello Madhu,</P><P></P><P>Glad to help where I can, but please be more specific in your request. Now it looks like an exam question...</P><P></P><P>Regards,</P><P></P><P>johan</P></BODY></HTML> Wed, 03 Dec 2014 08:52:03 GMT https://community.qlik.com/t5/QlikView/Hi/m-p/765323#M1041858 puttemans 2014-12-03T08:52:03Z