topic Re: set analysis syntax in QlikView

set analysis syntax

wynnjimbbt — Sat, 16 Nov 2024 05:08:11 GMT

The variable below works; but I need to return the date and get errors with my set expression:

variable:

sum({$< [Week Ending]=, DGdate = {'$(=Max({$<LogonID ={"*"},[Week Ending]= >}DGdate))'} >} [Avg Collected Balance])

Need:

date({$< [Week Ending]=, DGdate = {'$(=Max({$<LogonID ={"*"},[Week Ending]= >}DGdate))'} >})

the error is "Error in expression: ')' expected

Re: set analysis syntax

sunny_talwar — Mon, 26 Nov 2018 18:09:06 GMT

Did you forget to add the date field in the expression?

Date(Only({$<[Week Ending], DGdate = {'$(=Max({$<LogonID ={"*"}, [Week Ending]>} DGdate))'}>} DGdate)

Re: set analysis syntax

MohammedMustaq — Mon, 26 Nov 2018 16:08:51 GMT

Try This.

=sum({$< [Week Ending]=, DGdate = {"=$(=Max({$<LogonID ={"*"},[Week Ending]= >}DGdate))"} >} [Avg Collected Balance])

Mohammed Mustaq

set analysis syntax

wynnjimbbt — Mon, 26 Nov 2018 17:33:23 GMT

re-stating the question:
ePortfBal; the variable below works correctly:

sum({$< [Week Ending]=, DGdate = {'$(=Max({$<LogonID ={"*"},[Week Ending]= >}DGdate))'} >} [Avg Collected Balance])

I need to return in a text box the date that the variable selects; so I removed Sum() and used Date(). With the statement below I get syntax issues.

date({$< [Week Ending]=, DGdate = {'$(=Max({$<LogonID ={"*"},[Week Ending]= >}DGdate))'} >})

the error is "Error in expression: ')' expected

Re: set analysis syntax

sunny_talwar — Mon, 26 Nov 2018 17:35:49 GMT

Date for what?

Re: set analysis syntax

wynnjimbbt — Mon, 26 Nov 2018 18:05:38 GMT

DGdate

Re: set analysis syntax

sunny_talwar — Mon, 26 Nov 2018 18:10:58 GMT

Do you expect to see a single date? or do you need to use Min or Max to get one date from multiple possible dates? Try one of these

If the expected output can only have a single value

Date(Only({$<[Week Ending], DGdate = {'$(=Max({$<LogonID ={"*"}, [Week Ending]>} DGdate))'}>} DGdate)

or if you need Min or Max date from multiple date values

Date(Max({$<[Week Ending], DGdate = {'$(=Max({$<LogonID ={"*"}, [Week Ending]>} DGdate))'}>} DGdate)

Date(Min({$<[Week Ending], DGdate = {'$(=Max({$<LogonID ={"*"}, [Week Ending]>} DGdate))'}>} DGdate)