Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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