Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. 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.