topic Re: Pivot Table: sum of 1 dimension in QlikView

Pivot Table: sum of 1 dimension

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

Hello,

I'm trying to recreate a table that was previously used in Excel and I'm stuck...

Here's the straight table

My dimension "Activité" has several operations that are used in the making of each "Article"

The expression is the total time (in hundredths) used for each activity

Here is the Pivot table:

I'm unable to find how I could get a final column containing the SUM of the time for each Article like in my Excel file

I tried several ways (aggr function, ...) but I'm stuck

Any help is appreciated

Thanks !

Re: Pivot Table: sum of 1 dimension

YoussefBelloum — Wed, 25 Apr 2018 08:34:53 GMT

Hi,

you will need to add more details here, try to attach sample data or sample app to take a look

Re: Pivot Table: sum of 1 dimension

fgirardin — Wed, 25 Apr 2018 10:26:44 GMT

Hi,

I'd like to be able to show the total for each rows, as per this mock-up example

Dimension developed is "ACTIVITY" (in blue)
Expression is "TIME" (in red)

What I would like to achieve "TOTAL TIME" (adding all the time of each activities) (in green)

Thank you

Re: Pivot Table: sum of 1 dimension

YoussefBelloum — Wed, 25 Apr 2018 11:38:23 GMT

Can you scramble the data if it is sensitive and attach a sample app?

I have to test it

Re: Pivot Table: sum of 1 dimension

rubenmarin — Wed, 25 Apr 2018 11:56:10 GMT

Hi Fabien, if the expression is just Sum(TIME), checking the 'show partial sums option' for Activité dimension in presentation tab should work. Sometimes with vertical dimensions needs to save, close and open to refresh the chat and see the totals.

If the expression is more complicated the Aggr option will be like:

Sum(Aggr(CurrentExpression, Dim1, Dim2... DimN))

Re: Pivot Table: sum of 1 dimension

fgirardin — Wed, 25 Apr 2018 12:38:58 GMT

Here is a qvw file with some of the same data (Inline)

Dropbox - pivot_activite.qvw

Re: Pivot Table: sum of 1 dimension

YoussefBelloum — Wed, 25 Apr 2018 12:50:14 GMT

PFA

Is this what you need ?

Re: Pivot Table: sum of 1 dimension

fgirardin — Wed, 25 Apr 2018 20:07:37 GMT

yes thats it!

i feel stupid now. i was sure that i tried 'show partial sums' before!!!???

thank you a lot

Re: Pivot Table: sum of 1 dimension

fgirardin — Wed, 25 Apr 2018 20:09:07 GMT

yes, thanks

as I said on Marin's post, i was sure that i tried it before....

thanks again

Re: Pivot Table: sum of 1 dimension

YoussefBelloum — Thu, 26 Apr 2018 07:28:21 GMT

no problem, you're welcome.

don't forget to close the thread