topic Nested Set Analysis Calculation in QlikView https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Calculation/m-p/172285#M41894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a column called visit frequency and i find the average of visit frequency for every shop for the particular date range using set analysis.This expression works fine.</P><P>Avg({&lt;Date = {"&gt;=$(=addmonths(only([First Date]),0))&lt;=$(=addmonths(only([Last Date]),0))"},Month=,Week=&gt;} [Visiting Frequency])</P><P>Next i have to calculate the number of shops corresponding to the average visit frequency for the same date range by using the above expression.</P><P>Please help me out to solve the problem.</P><P></P><P></P><P></P></BODY></HTML> Wed, 02 Dec 2009 20:58:24 GMT 2009-12-02T20:58:24Z Nested Set Analysis Calculation https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Calculation/m-p/172285#M41894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a column called visit frequency and i find the average of visit frequency for every shop for the particular date range using set analysis.This expression works fine.</P><P>Avg({&lt;Date = {"&gt;=$(=addmonths(only([First Date]),0))&lt;=$(=addmonths(only([Last Date]),0))"},Month=,Week=&gt;} [Visiting Frequency])</P><P>Next i have to calculate the number of shops corresponding to the average visit frequency for the same date range by using the above expression.</P><P>Please help me out to solve the problem.</P><P></P><P></P><P></P></BODY></HTML> Wed, 02 Dec 2009 20:58:24 GMT https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Calculation/m-p/172285#M41894 2009-12-02T20:58:24Z