topic Re: 'Secondary' Calculations in Loadscript? in QlikView

'Secondary' Calculations in Loadscript?

Mon, 13 Jul 2015 13:48:17 GMT

Hi there,

I am working with Twitter data. Each tweet has a User ID (who sent it), and a classification: Boo, Cheer, Other.

I want to calculated, as a percentage by user, Boos, Cheers and Others.

I.e. Alex sent 10 tweets, three boos and seven cheers.

Alex's boo percentage is 30%.

This has to be at a user level so I can roll it up - i.e. the average boo % across all the users (calculated at a user level) is 15.3%.

I tried a load where I had

LOAD

Username,

count(Boos)/count(Tweet ID) as % Boos

But that didn't work. Any ideas? Thank you so much.

sunny_talwar — Mon, 13 Jul 2015 13:56:24 GMT

Did you use the group by statement?

LOAD Username,

Count(Boos)/Count(Tweet ID) as % Boos

Resident source

Group By Username;

Mon, 13 Jul 2015 16:32:59 GMT

Genius!

sunny_talwar — Mon, 13 Jul 2015 16:39:44 GMT

Awesome

I am glad it worked.

Best,

Sunny