Please, please help... what are these fields?

[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

[MK_QSL · Accepted solution]

CR means Credit Note..... When customer returns goods due to some issues... we need to raise credit notes against invoice raised.

IN means simple INVOICE.....

If We INVOICED 50pc of Product A and CN is for 10pc for the same product... Final Result would be 40pc.

Sales Value means the value at which we sold any part and

Cost Value means the value at which we purchased this part from our supplier.

Let me give you simple example.

We are buying Product A from Germany at €100/pc and bought 10pc... So total Cost value is €1000

Now sold 10pc of this item @ €150/pc... so total sales value is €1500

SO Margin is €1500-€1000 = €500

Margin % is €500/€1500 = 33.33%

Let me know if you want to know something more..

[MK_QSL]

If your requirement fulfilled, please close this discussion by selection Correct Answer or Helpful Answer

[Anonymous]

Diamond!