topic Weight data in QlikView

Weight data

Anonymous — Mon, 07 Nov 2011 19:55:03 GMT

Hello,

How can I weight data? If anybody knows, please send me an example or explanation.

Thanks

Weight data

Mon, 07 Nov 2011 20:10:15 GMT

I suppose you have a weigth in your file, so create an expression :

Sum( Value * Weight) / Sum( Weight) to calculate a weighted-mean

Not sure it's what you want to achieve.

Weight data

Anonymous — Mon, 07 Nov 2011 20:23:47 GMT

My database has a lot of customers who have a different number of respondents by month.

In different programs use a command weight. Help me create this expession.

Regards,

Weight data

Mon, 07 Nov 2011 20:29:11 GMT

Hi Vovan4ik

I don't understand.

Please could you precise the structure of your data and the chart you want to display

Re: Weight data

Anonymous — Mon, 07 Nov 2011 21:27:42 GMT

How can I apply a weight to the data that I include in my analisys?

I want to compare the value for a selected Nameplate (Val1, or Val2, ...) to combined weighted value for other Nameplates.

I have variable Weight.

Please find my attached file.

Thank you in advance.

Re: Weight data

johnw — Mon, 07 Nov 2011 21:53:55 GMT

Perhaps this for the combined weighted value for other nameplates?

sum({<NAMEPLATE=E()>} iPSI10*WEIGHT)

/sum({<NAMEPLATE=E()>} WEIGHT)

Weight data

Anonymous — Tue, 08 Nov 2011 02:33:57 GMT

Hi John,

Could you help me to add your expession to mine

avg(ALL<Period> IF (COUNTRY='CANADA', iPSI10)) ?

Thank you,

Re: Weight data

johnw — Tue, 08 Nov 2011 17:34:45 GMT

I believe the keyword ALL has been depricated, and the preferred form is now {1} TOTAL. That gives us more of a hint how these might be combined. I'm not sure if this is exactly what you're looking for, but I'd think something like this:

sum({1<NAMEPLATE=E(),COUNTRY*={'CANADA'}>} total <Period> iPSI10*WEIGHT)/
sum({1<NAMEPLATE=E(),COUNTRY*={'CANADA'}>} total <Period> WEIGHT)

Re: Weight data

Anonymous — Tue, 08 Nov 2011 21:07:33 GMT

When I tried to use your expression in my qv, all my expression was red. I updated my qvfile. I’m a new in Qlikview.

Could you explain what does it mean command E() or try toadd it in my file.

I appreciate it.

Re: Weight data

johnw — Wed, 09 Nov 2011 01:12:51 GMT

I was able to cut and paste it in as a third expression, and it worked with no modification. See attached. I can't say whether or not the results are correct, but it returns data. What version of QlikView are you using? The expression won't work in versions 8 or lower. That's all I'm thinking of.

E() means "excluded". If you select a specific nameplate, that gives you all other nameplates. That was my interpretation of "combined weighted value for other Nameplates".

Re: Weight data

Anonymous — Wed, 09 Nov 2011 22:14:01 GMT

I'm using version 11. The expression returns data. QV underlines all expression, is it correct? The result is not correct, but close to. Why did you use sum instead avg? What's it COUNTRY* and 1<NAMEPLATE?

Thanks in advanced

Re: Weight data

johnw — Thu, 10 Nov 2011 00:01:01 GMT

I'm using version 10 SR3. It doesn't underline the expression on my computer.

I'm using sum because you asked for a weighted average, and that's how you calculate a weighted average. For example:

Value Weight
5 2
20 1

unweighted average = avg(Value) = 12.5
weighted average = sum(Value*Weight)/sum(Weight) = 10

COUNTRY*={'CANADA'} is the set analysis equivalent of if(COUNTRY='CANADA',...)

1 is set analysis for "all data"

< is the opening bracket for a set

You're getting confused by syntax. Go look up the syntax for set analysis.

Re: Weight data

Anonymous — Thu, 10 Nov 2011 02:03:37 GMT

Thank you so much for your help.

Re: Weight data

Anonymous — Wed, 09 May 2012 19:03:49 GMT

Hi John,

You were very helpful last time. How can I do weighted calculation in %?

I usually do:

Count({<[qID_3_Task completion]={'Yes'}>}[qID_3_Task completion])/

Count(TOTAL<MYear>[qID_3_Task completion])

I have variable WEIGHT, but I don't have any thoughts how to use it.

Please advise your idea.

Regards,