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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table

HI everybody!

I began working with QV not long ago and have a question,

How to transform the followinf table:

    

StartTransitEndsum(Weight)
ABC10
ABD20
ABE5
ABF30
ABG5
HIJ10
HIK10

into;

    

StartTransitEndsum(Weight)
ABC70
ABD70
ABE70
ABF70
ABG70
HIJ20
HIK20

I need to group the column with the result by "Transit" field but keeping the "End" column.

Is it possible to do in the diagram expressions?

1 Solution

Accepted Solutions
Not applicable
Author

Please try this in your expression

Sum(TOTAL<Start,Transit> Weight)

View solution in original post

2 Replies
Not applicable
Author

Please try this in your expression

Sum(TOTAL<Start,Transit> Weight)

Not applicable
Author

Nhu Ngo, thanks a lot, it works!