sell thru on basis of calendar

[riishabhz]

my calendar is working on this =Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)

but its not working on my sell thru code.

sell thru formula is :-=Sum (InvoiceQuantity)/Sum (TransactionQuantity)*100

i did like this to attach my calendar but its not working  and data is not showing ,=Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}(InvoiceQuantity)/(TransactionQuantity)*100)

please help

[Brett_Bleess]

Have a look at the following Design Blog post, I think it may be tied to what you are trying to do and may help you figure out what is going wrong with things.

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

If you want to search for other posts in this area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[sunny_talwar · Accepted solution]

Try this

Sum({<SalesDate = {'>=$(=Date(start))<=$(=Date(end))'}>} InvoiceQuantity)
/
Sum({<SalesDate = {'>=$(=Date(start))<=$(=Date(end))'}>} TransactionQuantity) * 100