Discussion Board for collaboration related to QlikView App Development.
i want to calculate a average of a factor in a column of a pivottable, irrespective of users selection.
Actually i have this in the formula for the calculation:
avg(if(datum_test>=vStartDatum and datum_test<=vEndeDatum, fr_faktor1))
If field "factor" in table "factor_ratenschema" not filled, use the factors of last 5 networkdays.Irrespective of users selection.
Hope somebody can help me.
Go to Solution.
Maybe it is because of the if statement. Replace it with set analysis (not very clear though):
View solution in original post
I suggest that you post a sample qvw to enable more accurate help.