Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
kunkumnaveen
Contributor III

how to make min fucntion to work

Hello  suppose if i got data like this

date    idnum

3 Jan      5

20 Jan    15

1 Feb      6

26 Feb     20    

expression: min(only({<idnum={20}>}Timestamp(date)),only({<LUid_measure={6}>}Timestamp(date)))

output i am expecting is :     1 Feb (with timestamp),but it throwing me error

Error i am getting is

Nested aggregation not allowed 



any help from you guys ....

thanks

naveen

1 Solution

Accepted Solutions
MVP
MVP

Re: how to make min fucntion to work

Try RangeMin() instead, like:

Rangemin(only({<idnum={20}>}Timestamp(date)),only({<LUid_measure={6}>}Timestamp(date)))

2 Replies
MVP
MVP

Re: how to make min fucntion to work

Try RangeMin() instead, like:

Rangemin(only({<idnum={20}>}Timestamp(date)),only({<LUid_measure={6}>}Timestamp(date)))

helena_isupova
New Contributor III

Re: how to make min fucntion to work

Hi,

timestamp(min(aggr(only({<idnum={'20'}+{'6'}>} Timestamp(date)), idnum)))

This function will return the timestamp of idnum 6.

See the attached.

HIH

Elena