Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
ext_bay
New Contributor III

Re: FirstSortedValue Aggr double values

Ok cool, the only I don't understand yet is the '1E10' component. What does it do?

MVP
MVP

Re: FirstSortedValue Aggr double values

1E10 equals 10000000000... I am dividing the TimeStamp by this number because I want TimeStamp to be used second when determining the sort order. For example, if you count is like this and timestamp in its numerical form is this

Name     Count     TimeStamp

Stijn          10          42000

Sunny          8          42150

xyz             10          41999

You will see Sunny as the top one, where as the top Name should be Stijn. So Count + TimeStamp/1E10

ext_bay
New Contributor III

Re: FirstSortedValue Aggr double values

Got it, thank you very much!