topic Re: error in exp in QlikView

error in exp

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

currently my variable value is

vCurrentWeekk=Week(today())

so in expression I used : =Count({<WeekNumber={$(=vThisWeek)}>}id) this will only only this week data if I select other week in filter it is not reflecting so I tried below expression but its giving error

=if(GetSelectedCount()=0,week(today(),max(WeekNumber)))

Re: error in exp

its_anandrjs — Fri, 08 Sep 2017 07:04:47 GMT

Try this

=Count({<WeekNumber={ "$(=Max(WeekNumber))" }>}id)

=if( GetSelectedCount()=0,week(today() ),max(WeekNumber))) // In this you forget ")"

Re: error in exp

Anil_Babu_Samineni — Fri, 08 Sep 2017 07:05:57 GMT

May be missed parenthesis

=if(GetSelectedCount()=0,week(today()),max(WeekNumber))

Re: error in exp

soniasweety — Fri, 08 Sep 2017 07:06:50 GMT

still error in expression

Re: error in exp

soniasweety — Fri, 08 Sep 2017 07:07:10 GMT

still same error

Re: error in exp

its_anandrjs — Fri, 08 Sep 2017 07:07:38 GMT

Actually this is correct statement

=Count({<WeekNumber={ "$(=Max(WeekNumber))" }>}id)

=IF( GetSelectedCount()=0, Week(Today()), Max(WeekNumber))

Re: error in exp

soniasweety — Fri, 08 Sep 2017 07:09:01 GMT

still the error in expression

Re: error in exp

Anil_Babu_Samineni — Fri, 08 Sep 2017 07:09:17 GMT

May be this? Try and check

=Count({<WeekNumber={'$(=Week(Today()))'}>}id)

Re: error in exp

Kushal_Chawda — Fri, 08 Sep 2017 07:11:57 GMT

create variable on front end with below expression

=if(GetSelectedCount(Week)=0,week(today()),max(WeekNumber))

now try this expression

=Count({<WeekNumber={"$(=vThisWeek)"}>}id)

=Count({<WeekNumber={"$(vThisWeek)"}>}id)

Update: Error corrected in variable expression

Re: error in exp

its_anandrjs — Fri, 08 Sep 2017 07:22:25 GMT

Try this as well

=Count( {<WeekNumber={ "$(=Max(WeekNumber))" }>} id )

=Count( {<WeekNumber={ '$(=Max(WeekNumber))' }>} id )

=IF( GetSelectedCount()=0, Week(Today()), Max(WeekNumber))

=IF( GetSelectedCount() = IsNull(), Week(Today()), Max(WeekNumber))

Re: error in exp

Kushal_Chawda — Fri, 08 Sep 2017 07:23:41 GMT

Have you tried above?

Re: error in exp

soniasweety — Fri, 08 Sep 2017 07:25:51 GMT

yes kush,

I just missed to pass the filed inside the get function,its working now.

Re: error in exp

Anil_Babu_Samineni — Fri, 08 Sep 2017 07:29:33 GMT

You could use this too?

=if(GetFieldSelections(WeekNumber)=0,week(today()),max(WeekNumber))

Re: error in exp

soniasweety — Fri, 08 Sep 2017 08:43:39 GMT

yes used the same