Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hi

please see below attachments i want to

The data model should associate the following tables:

Trades – FACT table

Products – links to trade using PRODUCTCLASSID

Desk – links to trade using SALESDESKID

Exchange – links to Trade using EXCHANGEID

Sector – links to Trade using SectorID

DIMENSIONS     All the dimensions such as client account, client, product, region , date etc are easily identifiable

MEASURES         You must make a minimum of 5 KPI’s based on your understanding of the data. Excluding the

                                COUNT(ID)                                         Number of transactions

                                SUM(TRADE REVENUE)                 Total Revenue

    should be able to see the number of transactions per sales desk in a map. (Add your own coordinates)

    Month to Date versus Last Year Month to Date, Month to Date versus Last Month to Date and variance

    This Year to Date versus Last Year to Date and variance.

7 Replies
tresesco
MVP
MVP

.................hi........................

Hi Madhu,

Sorry, not writing this to answer your query, but to query you one. Why have all your posts to have caption 'hi' ? I guess a meaningful heading could be better from many aspects. What do you think?

Screen Shot 12-03-14 at 04.19 PM.PNG.png

simondachstr
Specialist III
Specialist III

Do you want us to do your homework?

sujeetsingh
Master III
Master III

I will quote this a bad practise to just give a complete requirement better you try implementing your self and the ask the question where you get ill results.

I will recommend you to do by your own first.

Not applicable
Author

Thank you  tresesco for giving the suggestion  one interviewer given above data   if know please to do .

sujeetsingh
Master III
Master III

Tresco seems you have a sharp eyes for all stuffs by Madhu

jagadeesh_diamo
Contributor III
Contributor III

Hi Madhu,

Don't distress, our friends are just suggesting for your betterment, hope you understand and follow that... you can do yourself when you try for sometime. Good luck.

MarcoWedel

and all are still open ...