topic Re: Asof table null values with pivot table in QlikView

Asof table null values with pivot table

Wed, 25 Mar 2015 09:40:05 GMT

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

Re: Asof table null values with pivot table

Gysbert_Wassenaar — Wed, 25 Mar 2015 10:26:35 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Asof table null values with pivot table

Wed, 25 Mar 2015 15:00:15 GMT

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

Re: Asof table null values with pivot table

Thu, 26 Mar 2015 06:26:46 GMT

gwassenaar Any Idea?