Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate function in Calculated Dimension

Hi, i want to use aggregate() function in calculated Dimension how can i do? i am doing like below : =TRADES & '-' & MIN(TRADETIME) this is giving me error. Please help Regards, Jitendra K Vishwakarma

1 Solution

Accepted Solutions
6 Replies
ecolomer
Master II
Master II

Not applicable
Author

Sorry my meaning of aggregate function was i want to use sum() , min() & max() fucntion but it showing error //Error in Calculated Demintion i am using syntax : =TRADES & '-' & min(TRADETIME) actually i want chart on TRADES base only but want to display min(TRADETIME) also Thanks

Not applicable
Author

Sorry my meaning of aggregate function was i want to use sum() , min() & max() fucntion but it showing error //Error in Calculated Demintion i am using syntax : =TRADES & '-' & min(TRADETIME) actually i want chart on TRADES base only but want to display min(TRADETIME) also Thanks

marcus_sommer
MVP & Luminary
MVP & Luminary

You couldn't use a aggregation-function within a calculated dimension without wrapping it in an aggr() - therefore see the links with the very good explanations.

- Marcus

Not applicable
Author

Thanks Now i can understand