Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
dhanu_today
New Contributor III

Logic Help(Aggr with Max value)

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

2 Replies
MVP & Luminary
MVP & Luminary

Re: Logic Help(Aggr with Max value)

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)


talk is cheap, supply exceeds demand
MVP & Luminary
MVP & Luminary

Re: Logic Help(Aggr with Max value)

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)

OR

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))

OR

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

Regards,

jagan.