Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You might need to supply some sample data so we can see what we're working with here.
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.
Good spot Thirumala!
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.
Well done thirumalai
Can you send an attachment for clarity or screenshots?
Something like this:
Input:
Output:
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
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.