Qlikview Pivot

[markgraham123]

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.

[#2]

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 · Accepted solution]

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.