Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum({<SalesDate = {'>=$(=Date(start))<=$(=Date(end))'}>} InvoiceQuantity)
/
Sum({<SalesDate = {'>=$(=Date(start))<=$(=Date(end))'}>} TransactionQuantity) * 100
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
Try this
Sum({<SalesDate = {'>=$(=Date(start))<=$(=Date(end))'}>} InvoiceQuantity)
/
Sum({<SalesDate = {'>=$(=Date(start))<=$(=Date(end))'}>} TransactionQuantity) * 100