Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pacoli2013
Contributor

Column totals in PivotTable

Hello,

I have a Qlikview Document with a Pivot table (see attached QVD)

I have two tables loaded in my script: a Sales Table and a Deviation table

In my pivot table I have to dimensions a timegroup and the deviationdescription

The time group allows to choose between month, week and date

The deviationdescription has two columns/expressions per deviation

The two expressions are Sum(LineAmount)  and      Sum(LineAmount)/Sum(TotalAmount)

Now I need to add a column for the TotalAmount. This column should come between the column with the timegroup and the columns deviationdescription.

I tried to add a calculated dimension TotalAmount, between the two dimensions timegroup and the deviationdescription, but that didn’t work because I didn’t get the right format or when I added a format like = Num(Sum((TotalLineAmount),' ##0,00'))

I got a failure in my calculated dimension. See sheet two the Copy.

When I add a new expression for the total amount, this gives a new column per deviation and that is not what I want.

The Total Options in the presentation tab are not what I want because the have only totals on top or bottom and not left or right.

Hope Someone can help me,

Thanks in advance

Regards   

Court

Tags (1)
1 Solution

Accepted Solutions

Re: Column totals in PivotTable

Click here to see the attachment

Re: Column totals in PivotTable

4 Replies

Re: Column totals in PivotTable

Can you check if attached is what you were looking for?

pacoli2013
Contributor

Re: Column totals in PivotTable

Hello Sunny,

Can not see your attachment

Re: Column totals in PivotTable

Click here to see the attachment

Re: Column totals in PivotTable

pacoli2013
Contributor

Re: Column totals in PivotTable

Hello Sunny Thanks a Lot

Community Browser