Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Text box is not displaying worst performing , when there is no selection ?

Hi All ,

Text box is not displaying worst performing , when there is no selection ? Also Not getting the date when max sale happened

1.PNG

2.PNG

Not getting the date when max sale happened3.PNG

Not getting date when max sale happened

4.PNG

1 Solution

Accepted Solutions
Highlighted

Re: Text box is not displaying worst performing , when there is no selection ?

Hi, you can try filtering stores with sales:

=FirstSortedValue({<Store={"=Count(Sales)>0"}>} Store,aggr((sum(Sales)),Store),1)

View solution in original post

4 Replies
Highlighted
Master
Master

Re: Text box is not displaying worst performing , when there is no selection ?

Hi,

If multiple expression values of function FirstSortedValue() have the least sort-order, the function will return NULL. Maybe if you have no selection, you just have a few identical minimum values?

Regards,

Andrey

Highlighted

Re: Text box is not displaying worst performing , when there is no selection ?

Hi, you can try filtering stores with sales:

=FirstSortedValue({<Store={"=Count(Sales)>0"}>} Store,aggr((sum(Sales)),Store),1)

View solution in original post

Highlighted
Specialist
Specialist

Re: Text box is not displaying worst performing , when there is no selection ?

Thank you so much Marin .

But can you please explain , what was going wrong in my case !

Highlighted

Re: Text box is not displaying worst performing , when there is no selection ?

Not sure but I think that it returned all stores without sales, and FirstSortedValue returns Null() when there are more than one value in the same sorted value (zero in this case).