Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Re: MAX COUNT and its value in PIVOT Table

You're welcome, hope it won't affect your performance and works fine.

If there is no problem, please help to closed this questions.

And if any problem please tell me.

Thanks.

Aiolos

Highlighted
Creator II
Creator II

Re: MAX COUNT and its value in PIVOT Table

Zhao, could u pls explain - sign in front aggr

Highlighted
Partner
Partner

Re: MAX COUNT and its value in PIVOT Table

Sorry, what's the meaning of "sign in front aggr" ?

Do you mean the function "aggr" ?

Aggr is just a group by, it's not too hard. It just group by Month and Cost to calculate the count(cost).

Thanks.

Aiolos

Highlighted
Creator II
Creator II

Re: MAX COUNT and its value in PIVOT Table

minus sign before aggr function..

Highlighted
Partner
Partner

Re: MAX COUNT and its value in PIVOT Table

oops...sorry for that,

because of the firstsortedvalue, I use rank = 1, so the sort is from minus to max. But I want to get the max value, so I use the minus sign.

Highlighted
Creator II
Creator II

Re: MAX COUNT and its value in PIVOT Table

tnx  a lot....