topic Set Analysis Help me in QlikView

Set Analysis Help me

MarcoARaymundo — Thu, 22 Aug 2013 13:50:15 GMT

hi!

I need to create one set analysis to summarize values by date. wherein:

SALE_DATE and EXPIRE_DATE.

For each SALE_DATE have EXPIRE_DATE => ex: SALE_DATE (02/01/2013) => EXPIRE_DATE (15/02/2013).

Now I want to summarize sales by month and the same month to summarize the amounts due.

ex:

MONTH/YEAR	SALE	RECEIVABLE
01/2013	100.000.000	120.000.000
02/2013	150.000.000	130.000.000

The information will be displayed in a bar graph.

Any idea?

Gysbert_Wassenaar — Thu, 22 Aug 2013 14:07:17 GMT

I don't think set analysis is going to help you, but perhaps I don't understand what you want. See attached example.

MarcoARaymundo — Thu, 22 Aug 2013 15:17:27 GMT

G Wassenaar thank you.

I need to calculate the days in accounts receivable, which uses the total receivables divided by the average sales of the same period.

DAR = Sum (Receivables) / (Sum (Sales) / 30)

I have only one fact table per invoice.

In the attached file is a sample of the data already summarized by date.

Need to put on red table: Sum (Receivables) and Sum (Sales) / 30, in order to synchronize sales months with the same months of receipt.

I hope I have explained better