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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-12-11 04:09 AM

Analytic Functions

Hi All,

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

Regards,

Gokul

Labels (1)
Labels
4,994 Views
0 Likes
12 Replies
jyothish8807
Master II
Master II
‎2014-12-11 11:41 PM

In response to

Hi Gokul,

Try in sort tab and sort it by expression.

hope it helps.

Regards

KC

Best Regards,
KC
335 Views
0 Likes
tresB
Champion III
Champion III
‎2014-12-11 11:43 PM

In response to

Check this attached sample.

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

stacked chart sorting issue_tres.qvw
335 Views
Anonymous
Not applicable
‎2014-12-12 02:37 AM
Author

In response to

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

BR

Serhan

335 Views