topic Qlikview Pivot in QlikView

Qlikview Pivot

markgraham123 — Tue, 09 Jun 2015 18:57:39 GMT

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.

Wed, 10 Jun 2015 08:55:56 GMT

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 — Wed, 10 Jun 2015 14:13:16 GMT

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.