topic Re: Create a plain table in qlikview in QlikView

Create a plain table in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i have a table with two columns year, month.

Now i want to create a table with columns year, month, sum of sales over year, sum of sales over month.

how to achieve it in qlikview?

Peter_Cammaert — Thu, 07 Jul 2016 12:06:16 GMT

Add two expressions:

=sum(Sales) // will calculate sum of sales over month

=sum(Total <Year> Sales) // will calculate sum of sales over year

Best,

Peter

Anonymous — Fri, 08 Jul 2016 08:27:12 GMT

can u elaborate that?

have to create a table with four columns