topic Re: How to Create Simple Table? in QlikView

How to Create Simple Table?

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

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

Re: How to Create Simple Table?

ciaran_mcgowan — Thu, 07 Jul 2016 16:16:43 GMT

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

Re: How to Create Simple Table?

trdandamudi — Thu, 07 Jul 2016 16:21:25 GMT

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.

Re: How to Create Simple Table?

ciaran_mcgowan — Thu, 07 Jul 2016 16:24:51 GMT

Good spot Thirumala!

Re: How to Create Simple Table?

Anonymous — Fri, 08 Jul 2016 07:06:19 GMT

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.

Re: How to Create Simple Table?

akpofureenughwu — Fri, 08 Jul 2016 07:20:02 GMT

Well done thirumalai

Re: How to Create Simple Table?

akpofureenughwu — Fri, 08 Jul 2016 07:20:44 GMT

Can you send an attachment for clarity or screenshots?

Re: How to Create Simple Table?

varshavig12 — Fri, 08 Jul 2016 07:49:49 GMT

Something like this:

Input:

Output:

Re: How to Create Simple Table?

akpofureenughwu — Fri, 08 Jul 2016 07:50:22 GMT

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

Re: How to Create Simple Table?

Anonymous — Fri, 08 Jul 2016 08:22:42 GMT

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.

Re: How to Create Simple Table?

varshavig12 — Fri, 08 Jul 2016 09:52:31 GMT

Something like below:

and if not, post a sample data with expected output.

Re: How to Create Simple Table?

Anonymous — Fri, 08 Jul 2016 12:11:45 GMT

like that..how do u do it?

Re: How to Create Simple Table?

Anonymous — Fri, 08 Jul 2016 12:14:37 GMT

the second row of year column should not be empty

Re: How to Create Simple Table?

varshavig12 — Mon, 11 Jul 2016 03:33:34 GMT

Please post a sample data and the expected output.