topic Re: Help with expression in QlikView

Help with expression

Fri, 27 Mar 2015 17:21:03 GMT

I need help with an expression that I am using in a straight table to calculate a weighted average.

This is the expression:

=(Field_1*Field_2) /

(sum(total if((STATUS <> 'X' and STATUS <> 'C') and (DESC = 1 or DESC = 3 or DESC = 7), Field_2)))

I need the denominator to remain the same regardless of the current selection, but it is changing when I make a selection. How do I prevent this? I should note that putting a {1} won't work since I am looking at data based on the date so I need to leave that filter in place.

Thank you!

Re: Help with expression

sunny_talwar — Fri, 27 Mar 2015 17:35:00 GMT

Unless you put {1}, your denominator of your expression will change. You can may be tell it to change on date and not on anything else:

{1<Date = {'*'}>}

HTH

Best,

Sunny

Re: Help with expression

pokassov — Fri, 27 Mar 2015 17:36:18 GMT

Hi Matthew!

Can you attach your model?

Re: Help with expression

sunny_talwar — Fri, 27 Mar 2015 17:37:39 GMT

Try this expression (replace Date with your date field name)

=(Field_1 * Field_2) /

(Sum({1<Date = {'*'}>} TOTAL If((STATUS <> 'X' and STATUS <> 'C') and (DESC = 1 or DESC = 3 or DESC = 7), Field_2)))

Best,

Sunny