topic Re: error in expression in QlikView

error in expression

Thu, 17 Dec 2015 05:59:42 GMT

I create a line chart my expression is ::: Avg({[GROUP1]<[Gender]=Female >}UserScore_score) it show the error in expression GROUP1 is Alternate state plz correct me.

Thanks

MAdhu

Re: error in expression

amit_saini — Thu, 17 Dec 2015 06:06:18 GMT

Josna,

Try this:

avg(distinct{$<Gender={'Female'}>} UserScore_score)

avg({$<Gender={'Female'}>} UserScore_score)

Thanks,
AS

Re: error in expression

Thu, 17 Dec 2015 06:10:47 GMT

amit,

compulsory use alternate state

Thanks

Madhu

Re: error in expression

jagan — Thu, 17 Dec 2015 06:24:10 GMT

Hi,

Try this expression

Avg({[GROUP1]<[Gender]={'Female'} >}UserScore_score)

Hope this helps you.

Regards,

jagan.

Re: error in expression

amit_saini — Thu, 17 Dec 2015 06:26:37 GMT

Plz use group1 in place of distinct.

Thanks,
AS

Re: error in expression

Thu, 17 Dec 2015 06:31:26 GMT

Hi,

Try this:

Avg({[GROUP1]}{<[Gender]={'Female'} >}UserScore_score)

Re: error in expression

PradeepReddy — Thu, 17 Dec 2015 06:43:49 GMT

try this..

Avg({[GROUP1]<Gender={'Female'}>}UserScore_score)

Re: error in expression

Kushal_Chawda — Thu, 17 Dec 2015 07:19:14 GMT

Just need below modification (in red) for your expression else it's fine

= Avg({[GROUP1]<[Gender]={'Female'} >}UserScore_score)