Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
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
rubenmarin

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
ahaahaaha
Master
Master

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

rubenmarin

Hi, you can try filtering stores with sales:

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

View solution in original post

shekhar_analyti
Specialist
Specialist
Author

Thank you so much Marin .

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

rubenmarin

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).