Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Here is an example of what I am looking to achieve in QlikSense using SumProduct function in Excel, Please let me know how we can get the similar calculation in QlikSense.
This is my Expression what I have tried but doesn't seem to work.
Sum(Total Count +Add count) * [Total Sales]
Regards,
Hari.
Hi Friend,
i couldn't understand the intention. But based on your expectation we can achieve by below expression:
Sum(Total(TotalSales*(TotalCount+Addcount)))
Thanks