topic Problem Set Analisys Average in QlikView

Problem Set Analisys Average

spividori — Fri, 12 Nov 2010 22:57:19 GMT

Hi!.

When I select a value in the To column (For example: 2/11/2010), I need the PV pivot table showing all the values for each value in the Days column (30, 60, 90 ...)

Attached file for better understanding.

Thanks.

Problem Set Analisys Average

Fri, 12 Nov 2010 23:18:10 GMT

The problem is that you're using a dimension from an unrelated table to create your summary 'buckets'.

There is no association between PromedeoVentas and Ventas, so, asking QV to summarize Ventas records into PromedeoVentas buckets is nonsense.

Your pivot table needs to bucket out your fact table data in terms of itself, or a related table.

One option is to define the dimension in your pivot table this way:

=AGGR(CLASS(VtaMesHasta-VtaMesDesde, 30), Need some kind of unique identifier here)

But your dataset is incomplete. I have no way to identify each unique instance of a 'Ventas', so I can't calculate the 'days' column for each of them.

Problem Set Analisys Average

Miguel_Angel_Baeyens — Sat, 13 Nov 2010 01:35:58 GMT

Hi,

I'd try the intervalmatch - left join approach, so you can link those date ranges and Fecha field and get the results you want. Check the example code posted here.

Hope that helps.