topic Re: Adding new rows with calculations in QlikView

Adding new rows with calculations

Thu, 19 Mar 2015 14:36:31 GMT

The attachment shows the format that I want. All bold cells are the rows I must add.

I have a relationship Division-----Group------Company.

I don't know if for the Total CompanyName# and FINAL TOTAL is needed generating it by QV "SubTotals" option or it is calculated by Expression as I suppose?

I already have this format with only CompanyName# and value columns but without those bolded fields, I want it to show up in Straight Table!! is it possible to do this? I am using SQL database only. Can't use Excel files.

Probably I will use scripting for this. If some information missing please let me know, this is urgent!

Re: Adding new rows with calculations

Anonymous — Thu, 19 Mar 2015 16:55:13 GMT

Hi Mark,

can you give the excel file with the exact calculation

is it ok if i replicate this using script as i am able to do it ????

Regards

Harsha

Re: Adding new rows with calculations

Thu, 19 Mar 2015 18:37:29 GMT

its a database I'm using. I have no excel sheet. That file was just my final presentation as result of a report. You mean the qvw?

Re: Adding new rows with calculations

Clever_Anjos — Thu, 19 Mar 2015 18:48:21 GMT

What about a pivot table with subtotals for each dimension?

Presentation Tab, tick "Show Partial Sums" for each dimension

Re: Adding new rows with calculations

Thu, 19 Mar 2015 18:54:18 GMT

this is the straight table with the result i want but adding the rows shown above. I already tested pivot table before but I dont think it will work. Let me try and I will reply again.

Re: Adding new rows with calculations

Thu, 19 Mar 2015 19:08:45 GMT

OK. As I have 3 dimensions. I typed in Enable Conditional = 0 for Division and Group to hide them and in Presentation I checked Show Partial Sums and It shows the Final Total and not Totals by group separately in the only dimension that I should have "Company" column. I have other expression already calculated but they are shown after those columns you see in the screen above, I actually want them to appear below each Group Totals and same as below Division Totals. Am I clear enough?