topic Problem Regarding set analysis in QlikView

Problem Regarding set analysis

Mon, 20 Oct 2014 10:11:09 GMT

Hi All,

I want to calculate average salary from 1-Feb 2014 to till date i.e today()-1 .....How i can calculate in set analysis ....

I tried with the below code but did not get the proper answer :----

Sum( {< Date={"$(=Makedate(2011,02,05)) "} >} SALARY)

Please check and do needful for me ..................

Sarfaraz

ogster1974 — Mon, 20 Oct 2014 10:27:43 GMT

Try AVG({<Date={">=01/02/2014 <=Today()-1"}>} Salary)

anbu1984 — Mon, 20 Oct 2014 10:34:01 GMT

Sum( {< Date={">=$(=Makedate(2011,02,05))<=$(Date(Today()-1))"} >} SALARY)

Mon, 20 Oct 2014 10:50:36 GMT

Thnaks a lot anbu .....your solution is working as expected .......and andy i tried with your solution also but did not work ....

Anyway thanks a lot for your reply !!!!!!!!!!

Sarfaraz

anbu1984 — Mon, 20 Oct 2014 10:57:50 GMT

Please mark as answered/helpful if our replies resolved your query