topic Re: Logic Help(Aggr with Max value) in QlikView

Logic Help(Aggr with Max value)

dhanu_today — Fri, 11 Jul 2014 09:40:18 GMT

Hi Everyone,

I have 3 categories.The 2 expressions for two categories are working fine and coming to third category logic level I have Number field more than one time then that cases I have to capture the highest amount only.(i.e. only for the 3 expression only not for the first and second)

The logics which I have written in the expressions are below;

Exp1:Working Fine

sum({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Salary Mnemonics"}>}AMOUNT)

Exp2:Working Fine

sum({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Salary Narrations"},Number =E({<CATEGORY ={"Salary Mnemonics"}>})>}AMOUNT)

Exp3:

sum({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Above 5000"},Number =E({<CATEGORY ={"Salary Mnemonics","Salary Narrations"}>})>}AMOUNT)

Dummy Logic:

AGGR(MAX(AMOUNT),Number)

How to add the dummy logic expression to the Exp3.

Thanks,

Dhanu

Re: Logic Help(Aggr with Max value)

Gysbert_Wassenaar — Fri, 11 Jul 2014 10:00:47 GMT

I have no idea what you're really asking. Maybe this?

max({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Above 5000"},Number =E({<CATEGORY ={"Salary Mnemonics","Salary Narrations"}>})>}AMOUNT)

Re: Logic Help(Aggr with Max value)

jagan — Fri, 11 Jul 2014 10:03:07 GMT

Hi,

Try this expression

Since you have Number as dimension you don't need Aggr()

MAX({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Above 5000"},Number =E({<CATEGORY ={"Salary Mnemonics","Salary Narrations"}>})>} AMOUNT)

sum({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Above 5000"},Number =E({<CATEGORY ={"Salary Mnemonics","Salary Narrations"}>})>}

AGGR(MAX({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Above 5000"},Number =E({<CATEGORY ={"Salary Mnemonics","Salary Narrations"}>})>} AMOUNT),Number))

AGGR(MAX({<SAL_CREDIT_MNTH = {"May"},CATEGORY ={"Above 5000"},Number =E({<CATEGORY ={"Salary Mnemonics","Salary Narrations"}>})>} AMOUNT),Number)

Regards,

jagan.