topic Re: Firstsorted Value in QlikView

Firstsorted Value

fheidenstecker — Thu, 26 Apr 2018 16:58:54 GMT

Hi there,

i have a question regarding firstsortedvalue, which is driving me nuts

I prepared an example: I have 2 different Values and an Id. I want to count the Event with the lowest Index. But whatever i try, it always shows me both values

My exprected Result is:

Header 1	Header 2
Value	Count
Test1	2

Please see attached file.

This is just some sample data i created, cause i can't share my real data. The real data is a list of events for each date. I want to count for each day what event occured first 😉

Thanks,

Fabian

Re: Firstsorted Value

sunny_talwar — Thu, 26 Apr 2018 17:01:53 GMT

Try this

=Count(Aggr(If(Value = FirstSortedValue(TOTAL <Day> Value,ID), 1), Day, Value))

Re: Firstsorted Value

fheidenstecker — Thu, 26 Apr 2018 17:07:27 GMT

Wow, thanks for the quick hint!

It works, and also for my real life Data!

Need some time to think about the nested use of if and aggr 🙂

Great!