Discussion board where members can get started with QlikView.
Hi All ,
Text box is not displaying worst performing , when there is no selection ? Also Not getting the date when max sale happened
Not getting the date when max sale happened
Not getting date when max sale happened
Hi, you can try filtering stores with sales:
View solution in original post
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?
Thank you so much Marin .
But can you please explain , what was going wrong in my case !
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).