Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Valued Contributor

Problem Set Analisys Average


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.


Tags (1)
2 Replies
Not applicable

Problem Set Analisys Average

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


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.

Community Browser