Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

Problem Set Analisys Average

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.

2 Replies
Not applicable

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.

Miguel_Angel_Baeyens

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.