topic Net Additions calculation for Last Years dynamic not showing proper in set analysis in QlikView

Net Additions calculation for Last Years dynamic not showing proper in set analysis

vikasmahajan — Thu, 25 Jun 2015 07:12:34 GMT

Dear All,

Find attachment of my data model image as well as pivot table which I created for head count analysis in this for Last year Net additions was 53 for 01/04/2015 to 30/06/2015 , Quarter Q1 period when we select Q1 from list box.

In dashboard we want to show net additions dynamic so we want as per dashboard LYS fig correct appering when select Qtr.PNG file .

Expression used to calculate Net Additions for Last Year :

=COUNT({$<FinancialYear=,[DOJJ]={'>=$(=Date(vLyStartDate))<=$(=Date(vLyEndDate))'}>} DISTINCT [EMPID])

COUNT({$<FinancialYear=,[DOL]={'>=$(=Date(vLyStartDate))<=$(=Date(vLyEndDate))'}>} DISTINCT [EMPID])

Variable Defined :

vLyStartDate : =date(addyears(max(YearStart), -1), 'DD/MM/YYYY') Values : ( 01/04/2014)

vLyEndDate := date(addyears(max(YearEnd), -1), 'DD/MM/YYYY') Values : (31/03/2015)

How to build expression Set Analysis for without selection quarter we need to show Net Additions ( 53 ) in Last Year

Thanks

Vikas

Re: Net Additions calculation for Last Years dynamic not showing proper in set analysis

swuehl — Thu, 25 Jun 2015 09:51:32 GMT

Could you upload a small sample QVW?

I think it's hard to answer that question without knowing the details of your data model, e.g. how the link table was built up.

Re: Net Additions calculation for Last Years dynamic not showing proper in set analysis

vikasmahajan — Sat, 27 Jun 2015 05:11:55 GMT

Thanks

Swuehl In Following Link I have got solution from Manish data model

https://community.qlik.com/thread/153749

Can check and let me know what could me problem ?

Vikas