Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

How to write expression for monthly Rate X sales by month ?

Hi All

I have a sales table below :-

month rate v1.png

Rate for 20 Jan = 20 

Rate for 20 Feb = 25

Sales for 20 Jan = 270,569

Sales for 20 Feb = 446,865

How to write expression = 20 X 270,569 + 25 X 446,865 

Paul

 

 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Try something like this:

=Sum(Aggr(Only(Rate)*Sum(sales), YearMonth))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Partner
Partner

Try something like this:

=Sum(Aggr(Only(Rate)*Sum(sales), YearMonth))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Master
Master

Hi Sir

Thank you very much

Paul