Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create a plain table in qlikview

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?

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

can u elaborate that?

have to create a table with four columns