Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
markgraham123
Specialist
Specialist

Qlikview Pivot

Hi,

I have 2 columns - ID and Velocity

Velocity is calculated from variables and a complex expression.. Sum(....V1.)

I'm trying to get the relative percentage for every value in velocity but unable to.

I have tried velocity/Sum(Velocity) .. but not working.

i can see the partial sums in the pivot.

I'm wondering why only Sum() operation is not working.

Can anyone pls help me.

1 Solution

Accepted Solutions
markgraham123
Specialist
Specialist
Author

Hi Hampus Andersson,

I just removed all the variables in the velocity and typed the full expression, SUM() worked for the column.

Thanks for your reply.

From my next posts, i will be asking the question with sample data.

Thanks for your time.

View solution in original post

2 Replies
Not applicable

Hi Mark,

I think a small file with sample data would be great beneficial here as its really hard troubleshooting your problem based on current information.

Good luck!

markgraham123
Specialist
Specialist
Author

Hi Hampus Andersson,

I just removed all the variables in the velocity and typed the full expression, SUM() worked for the column.

Thanks for your reply.

From my next posts, i will be asking the question with sample data.

Thanks for your time.