topic Modify expression in QlikView

Modify expression

Anonymous — Thu, 30 Aug 2012 15:09:27 GMT

Hi,

Please help me to modify expression avg({1} MyField)

I want to show avg of all, but manage by Filter MYear.

In my case if I select any month in MYear, it shows trend for all month.

Thanks,

Re: Modify expression

Thu, 30 Aug 2012 17:57:36 GMT

did you try creating a bookmark (Clear Other Fields - MYear)

and changing your expression to : avg( {MyBookMark} MyField) ?

Re: Modify expression

Anonymous — Thu, 30 Aug 2012 17:59:50 GMT

Thanks for reply,

Bookmark doesn't work when you publish it.

Cheers,

Re: Modify expression

Thu, 30 Aug 2012 18:07:26 GMT

did you try combine getfieldselection() ?

something like

avg({1<MYear={getfieldselections(MYear)}>} MyField)

Re: Modify expression

Anonymous — Thu, 30 Aug 2012 18:17:01 GMT

Something's wrong.

avg({1<MYear={getfieldselections(MYear)}>} MyField)

getfieldselections(MYear)}>} ----it doesn't reconise command.

Re: Modify expression

Thu, 30 Aug 2012 18:41:39 GMT

it was only an idea

but i'll try to write it myself

Re: Modify expression

Anonymous — Thu, 30 Aug 2012 18:52:41 GMT

I tried like it

avg(TOTAL<MYear> MyField).

It doesn't work with Filter

Re: Modify expression

Thu, 30 Aug 2012 18:59:26 GMT

if you select always one year this should work

sum({1<MYear={'$(=GetFieldSelections(MYear))'}>}MyField)

does this satisfy you?

Re: Modify expression

Thu, 30 Aug 2012 19:05:44 GMT

=sum({1<MYear={$(=GetFieldSelections(MYear,','))}>}MyField)

//i just remove ' sign

Re: Modify expression

Anonymous — Thu, 30 Aug 2012 19:24:58 GMT

It doesn't work.

I just copied your expression and fixed MyField.

Re: Modify expression

Anonymous — Thu, 30 Aug 2012 19:26:36 GMT

Filter works with this expression

avg(TOTAL<MYear>{$< Client*=, Industries*=>}[MyField])

but the result is wrong.

I need to investigate it.

Re: Modify expression

whiteline — Thu, 30 Aug 2012 19:28:10 GMT

=avg({1<MYear=P(MYear)>}MyField)

Re: Modify expression

Thu, 30 Aug 2012 19:35:48 GMT

you didn't tell you've got only two dimensions to clear:)

this should work

avg({$<Client=, Industries=>} MyField)

also whiteline got fine idea

Re: Modify expression

Anonymous — Thu, 30 Aug 2012 19:39:41 GMT

Thank you for your help.

You really helped me.