Asof table null values with pivot table

[#1]

Hi,

Have used the 'asof' table instead of Rangeavg function in script. The pivot table shows null values when no filters are applied only when I select any field value from first column(There are two columns in pivot table first is the group name and second is Month which is transposed) of pivot table the correct values are displayed in the entire row.

I want the values to be displayed before any selections are made.

gwassenaar

Rolling 12 months percentages

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[#3]

Ill explain, For the same application from the tagged post

The columns are dept, group, attrition month and reporting month

Dept and Group mapping is like this:

SSCol            GroupCol

SS1              Group123

SS2              Group123

SS3              Group123

SS4              Group456

SS5              Group456

SS6              Group456

and so on.

The attrition count and monthly headcount for the groups is as follows:

SSCol	Attrition Month	Attrition Count	Monthly Headcount
SS1	Jul 2014	7	15
SS2	Jul 2014	4	17
SS3	Jul 2014	3	14
SS4	Jul 2014	5	17
SS5	Jul 2014	3	16
SS6	Jul 2014	5	15
SS1	Aug 2014	3	12
SS2	Aug 2014	7	13
SS3	Aug 2014	5	18
SS4	Aug 2014	6	12
SS5	Aug 2014	5	13
SS6	Aug 2014	7	16

The Expression of attrition percentage for the month of july for group1 should be calculated such as sum of(Attrition Count) SS1+SS2+SS3/Avg of Monthly Headcount. i.e 14/46 = 30.43%

for grp 1 for the month of august : 14+15/((46+43)/2)  which is equal to 65.16%.

Here for month of august we take average so we divide by 2 assuming july is first month and August is second.

Want this as output of expression in a pivot table.

gwassenaar

Thanks,

Pratik

[#4]

gwassenaar Any Idea?