Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
manpri7078
Creator
Creator

YTD Expression similar to SUMPRODUCT in EXCEL

Hi All,

I am struck in one place. I have a new requirement to calculate YTD Average of some data for which I am attaching sample file.

In my sample file P&B Qty or Actual Qty have figures where Particulars is Metal.

Another line Item with the name of Alumina have other data such as effeciency, issue prices of both P&B and Actual.

I have given there my desired output which is calculated through EXCEL's very popular SUMPRODUCT formula. That desired output I want in my Sample Qlikview Document, which also I am attaching herewith.

I have made a simple Pivot chart for the same. Can any one please help how to achieve the results which can be easily done by SUMPRODUCT formula, but I have not found anything similar to that in Qlikview.

I hope I have been clear in explaining my problem and what I actually want.

Regards,

Manish Prasad

12 Replies
manpri7078
Creator
Creator
Author

Dear Sunny,

Thanks very much for your quick reply.

Regards,

Manish Prasad

manpri7078
Creator
Creator
Author

Dear Sunny

Thanks. I will certainly learn it.