Please, please help... explain these metrics

[Anonymous]

Hi

I found qlikview about 12x months ago and have been using it to report on IT systems, (computer systems), for a bank. I work as a data storage administrator, so the dashbboards i've been producing are all about, how much data, where, how long, hows it growing, etc, etc.

Passed the "Designer 11 exam" last month, I love Qlikview and would like to get a job doing just Qlikview, so... went to a few employment agencies who arranged some introductions / interviews with different qlikview consultancy firms.

One of the employers have given me a Case Study, (produce a qlikview application from some source data), as part of the interview. They've given me until Monday to complete it.

I'm comfortable with to build fact tables, dimension tables, master calendar tables, etc, etc, (join, intervalmatch, whatever), and create the application with Dashboard, Analysis and Reports tab, easy...

My problem is... The source data they've given me is Sales type data, (not something i've really worked with), and the fields on the "Transactions" table make little sense to me.

QUANTITY, SALES VALUE and COST OF SALES = sometimes are 0 and sometimes are negative

Also...

TRANS CODE = Is either CR or IN, (when it's CR the QUANTITY, SALES VALUE and COST OF SALES are 0 or negative and when it is IN the QUANTITY, SALES VALUE and COST OF SALES are positive numbers greater than 0).

Source Data file attached.

Please, please, please someone shed some light...

What is meant by QUANTITY, SALES VALUE and COST OF SALES and why when TRANS CODE is CR are they 0 or negative and why when TRANS CODE is IN are they positive numbers?

Thanks so much in advance

Thanks

Simon

[bbi_mba_76]

Hi,

I think you have to ask to the employer..

Generally there are credit notes, returned goods, ...  but I don't know so much

[MK_QSL · Accepted solution]

Looks like you have created two discussions for the same question.

Please check my reply on other discussion.

[albertovarela]

Hello Simon,

Before you start it is important to understand what the requirement/purpose of the app is. The fact that they have given you all these data doesn't mean you have to use it all. Maybe the test its not about building the app but to test your ability to gather requirements and ask the right questions...

Anyway, based on your explanation I assume that:

• Quantity: Number of units sold per transaction
• Sales Value: Total value of the transaction (Sales Value / Qty = Unit price)
• Cost of Sales: By definition this is the cost of goods of produced (or services) in a period of time. It doesn't include indirect expenses.
• Trans code:
  • CR: sounds like a Credit that doesn't affect inventory
  • IN: Invoice?

Hope this helps...