https://community.qlik.com/t5/App-Development/Qlik-Set-analysis-with-GetFieldSelections/m-p/1864696#M71370 <P>Hi All,</P> <P>I want to calculate the expression if there's no selection for Unit type then it should show sum of all six expression else it would show the solution as per the selection in Unit type.</P> <P><STRONG>I've attached the formula using for the same.</STRONG></P> <P>While using this expression, i can see the correct data but i am using rolling 12 months in set analysis which is not working correctly. it's showing a line chart of all dates.</P> <P>Can you please check and help me with correct formula so it can show results for rolling 12 months based on my requirement.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Sumit</P> <P>&nbsp;</P> Tue, 30 Nov 2021 04:13:32 GMT Sumit2504 2021-11-30T04:13:32Z https://community.qlik.com/t5/App-Development/Qlik-Set-analysis-with-GetFieldSelections/m-p/1864696#M71370 <P>Hi All,</P> <P>I want to calculate the expression if there's no selection for Unit type then it should show sum of all six expression else it would show the solution as per the selection in Unit type.</P> <P><STRONG>I've attached the formula using for the same.</STRONG></P> <P>While using this expression, i can see the correct data but i am using rolling 12 months in set analysis which is not working correctly. it's showing a line chart of all dates.</P> <P>Can you please check and help me with correct formula so it can show results for rolling 12 months based on my requirement.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Sumit</P> <P>&nbsp;</P> Tue, 30 Nov 2021 04:13:32 GMT https://community.qlik.com/t5/App-Development/Qlik-Set-analysis-with-GetFieldSelections/m-p/1864696#M71370 Sumit2504 2021-11-30T04:13:32Z