Getting Latest runs data based on Region in Pivot table

Tue, 26 Jan 2016 17:00:45 GMT

Hi,

Need help in getting the below requirement.

In a single QVW, one pivot should generate detailes of all Regions and all runs data. In another tab of same QVW, another pivot should show the consolidated report which should consider each regions latest run data.

Sample Data:

Region, Type, Run, Amounts

A, Base, 1, 100

A, Base, 2, 200

A, Stress, 1, 200

A, Stress, 2, 300

A, Stress, 3, 300

B, Base, 3, 40

B, Base, 4, 50

B, Stress, 3, 60

C, Base, 1, 20

C,Base, 4, 30

C, Stress, 2, 20

The QVD stores all the data. From that, regular pivot showsall runs details

But, a consolidation report should show the latest run details against Region and Type.

Consolidation View:

Region, Type, Run, Amount

A, Base, 2, 200

A, Stress, 3, 300

B, Base, 4, 50

B, Stress, 3, 60

C, Base, 4, 30

C, Stress, 2, 20

How can i achieve the consolidation report? How can i filter the data based on latest Run against Region and Type at Pivot level? Please guide me here. Thanks in Advance.

Re: Getting Latest runs data based on Region in Pivot table

maxgro — Tue, 26 Jan 2016 18:46:19 GMT

try with these expressions in the pivot (Region and Type as dimensions)

Max (Run)

FirstSortedValue (Amounts, -Run)

topic Re: Getting Latest runs data based on Region in Pivot table in QlikView

Getting Latest runs data based on Region in Pivot table

Re: Getting Latest runs data based on Region in Pivot table