Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Analytic Functions

Hi All,

Could anyone tell me if we can use aggr function in QlikView scripting?

Regards,

Gokul

12 Replies
jyothish8807
Master II
Master II

Hi Gokul,

Try in sort tab and sort it by expression.

hope it helps.

Regards

KC

Best Regards,
KC
tresesco
MVP
MVP

Check this attached sample.

Calculated dimension(adpr): =Dual(adpr,Aggr(sum(n),pr,adpr))

Anonymous
Not applicable
Author

Should definitely go for sorting "by Expression" and "Aggr()" as guys already suggested.

BR

Serhan