Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-10-18 05:31 PM

Pivot table aggregation issue.

Screen Shot 2013-10-18 at 2.17.56 PM.png

My report looks like this. it is pivot table chart..

The first 3 columns are dimensions and last column is sum(amount) expression.

I need to change the way 3rd column looks like.

The customer "Natiello Ernesto:Kitchen" has 3 invoices with item "Cabinets:Cabinet Pulls" but this report has aggregated the amount for all 3 invoices for this customer and shown as one row.

Is there any way I can show

Cabinets:Cabinet Pulls

                                      Castillo, Eloisa:Utility Room               127.00

                                      Castillo, Eloisa:Utility Room                100.80

                                                                  Total                         227.80

                                      Natiello Ernesto:Kitchen                             0

                                      Natiello Ernesto:Kitchen                             0

                                      Natiello Ernesto:Kitchen                        52.91

                                                                 Total                            52.91

Test2.qvw
2,403 Views
0 Likes
1 Solution

Accepted Solutions
preminqlik
Specialist II
Specialist II
‎2013-10-21 06:02 AM

In response to

for your first question answer : here whenever you write aggrigation expression in front end qlikview automatically aggrigate by the dimension by group( by)., so thats why i took another dimension rowno(), which gives unique identification number in the backend, so here we got another dimension ,here rowno() or new_dimension acting like invoice number or transaction time,. so thats why i added rowno() as new dimension ,and got the drill result.

for you second question answer : both are same

regards

Premhas

View solution in original post

1,538 Views
0 Likes
22 Replies
Not applicable
‎2013-10-18 05:35 PM
Author

Can you uplad the example?

1,235 Views
0 Likes
rustyfishbones
Master II
Master II
‎2013-10-18 05:35 PM

Can you add Invoice number as a Dimension?

1,235 Views
0 Likes
Not applicable
‎2013-10-18 05:44 PM
Author

In response to rustyfishbones

I can add that..

Do you think it can make a difference

1,235 Views
0 Likes
rustyfishbones
Master II
Master II
‎2013-10-18 05:45 PM

I think so

1,235 Views
0 Likes
Not applicable
‎2013-10-18 05:45 PM
Author

In response to

Should i upload and my QVD and QVW files?

1,235 Views
0 Likes
rustyfishbones
Master II
Master II
‎2013-10-18 05:47 PM

no just add a Dimension to the Chart with Invoice number, Is the Invoice number in your Data model?

1,235 Views
0 Likes
Not applicable
‎2013-10-18 05:48 PM
Author

In response to

The qvw its ok(:

1,235 Views
0 Likes
Not applicable
‎2013-10-18 05:50 PM
Author

In response to rustyfishbones

Screen Shot 2013-10-18 at 2.48.33 PM.png

It looks like this and subtotal appears at invoice number level which is not want i want.

I want it look like this

Cabinets:Cabinet Pulls

                                      Castillo, Eloisa:Utility Room               127.00

                                      Castillo, Eloisa:Utility Room                100.80

                                                                  Total                         227.80

                                      Natiello Ernesto:Kitchen                             0

                                      Natiello Ernesto:Kitchen                             0

                                      Natiello Ernesto:Kitchen                        52.91

                                                                 Total                            52.91

1,235 Views
0 Likes
Not applicable
‎2013-10-18 05:53 PM
Author

In response to rustyfishbones

yes, that's what i added "RefNumber"

what do you mean by "just add a dimension"?

Should i remove other dimensions?

1,235 Views
0 Likes