Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Create Simple Table?

how to create a plain table with columns year, month, sum of sales per year, sum of sales per month. the last two coulmns data should reflect over all rows.

how to achieve it in Qlikview

13 Replies
ciaran_mcgowan
Partner - Creator III
Partner - Creator III

You might need to supply some sample data so we can see what we're working with here.

trdandamudi
Master II
Master II

Please do not create multiple threads for the same issue. You already created a thread as below:

Create a plain table in qlikview

Peter has replied to your issue. Please continue on the existing thread and people will respond. You need to give enough information for others to take a look and suggest you with a solution.

ciaran_mcgowan
Partner - Creator III
Partner - Creator III

Good spot Thirumala!

Anonymous
Not applicable
Author

some one asked me like there is a sales table with columns year and month.

now in qlikview

how to create a plain table with columns year, month, sum of sales per year, sum of sales per month. the last two coulmns data should reflect over all rows.

how to achieve it in Qlikview??

try to answer question rather than spotting something.

akpofureenughwu
Creator III
Creator III

Well done thirumalai

akpofureenughwu
Creator III
Creator III

Can you send an attachment for clarity or screenshots?

varshavig12
Specialist
Specialist

Something like this:

Input:

Output:

akpofureenughwu
Creator III
Creator III

Hi Raju... No one is spotting anything here. Just send us an attachment of what you want to achieve.

A picture will make this task simple and easy to understand.

Thanks

Anonymous
Not applicable
Author

the output table should have four columns.

year, month, sum(sales)per year,Sum(sales) per month.

you have to generate the last 2 columns in qlikview.

that is the question i've been asked.