topic Re: Invalid expression in QlikView

Invalid expression

sandeepbijoor — Tue, 19 Dec 2017 05:41:34 GMT

if(match(Timesheet_Weekno,Max(Timesheet_Weekno)),[Project Manager Name]) as MaxWeekProjectManagerName

Why this expression is giving error ? Please help me

Re: Invalid expression

Anil_Babu_Samineni — Tue, 19 Dec 2017 08:56:58 GMT

Are you doing this in Expression or Script?

Re: Invalid expression

tresB — Tue, 19 Dec 2017 09:01:31 GMT

You are using aggregation function max(), that would require group by clause in the script when used with more fields in the load. Try like:

Load

Field1,

Field2

From <> group by Field1, Field2...;

Re: Invalid expression

its_anandrjs — Tue, 19 Dec 2017 09:07:34 GMT

In your expression you are using Max() which is require Group By statements and grouping on the dimension, so you can't use with out using Group By clause in your statement.

Try

Load

Fields1,

Fields2,

if(match(Timesheet_Weekno,Max(Timesheet_Weekno)),[Project Manager Name]) as MaxWeekProjectManagerName

From Source

Group By

Timesheet_Weekno,

[Project Manager Name],

Fields,,,,,;

Please read about the Aggr or Group By.

Re: Invalid expression

sushil353 — Tue, 19 Dec 2017 09:08:49 GMT

Hi,

Create your max function is some variable

LET vMaxMonth = Max(Timesheet_Weekno);

if(match(Timesheet_Weekno,'$(vMaxMonth )'),[Project Manager Name]) as MaxWeekProjectManagerName

HTH

Sushil

Re: Invalid expression

its_anandrjs — Tue, 19 Dec 2017 09:16:32 GMT

You can left join the MaxTimesheet_Weekno field while getting Max Timesheet_Weekno and then use this field for calcualtion.

Left Join(Source)

Load

Max(Timesheet_Weekno) a MaxTimesheet_Weekno

Resident Source;

Load *,

if(match(Timesheet_Weekno,MaxTimesheet_Weekno),[Project Manager Name]) as MaxWeekProjectManagerName

From Source;

Drop Table Source;

Re: Invalid expression

sandeepbijoor — Thu, 04 Jan 2018 11:00:30 GMT

Thank you everyone for help. Problem got solved by group by

Re: Invalid expression

oknotsen — Thu, 04 Jan 2018 14:05:53 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .