topic Re: set analysis in QlikView

set analysis

Anonymous — Wed, 14 Oct 2015 11:25:01 GMT

Hello Everyone

My instruction work correctly for each row but when you select some values in chart, it doesn't calculate correct avrage.

if(IsNull(RecieveMonth) ,Avg('42280'- SendMonth ), Avg(RecieveMonth-SendMonth))

i would much appreciate if any body here could helpme

miguelbraga — Wed, 14 Oct 2015 15:18:27 GMT

You need to convert 42280 to month like this month('42280') and transform your function to this:

if(IsNull(RecieveMonth) ,Avg(month('42280')- SendMonth ), Avg(RecieveMonth-SendMonth))

Anonymous — Sat, 17 Oct 2015 04:36:41 GMT

miguelbraga — Mon, 19 Oct 2015 08:22:31 GMT

If my answer was the right one, please, mark it as the correct

Anonymous — Mon, 19 Oct 2015 08:36:08 GMT

oh dear yes you right but my "Sendmonth" is not a date format it's number like 42280 so in this case it doesn't need to convert

ahmar811 — Mon, 19 Oct 2015 08:44:59 GMT

can you upload the .qvw file sample plz