Discussion board where members can get started with QlikView.
I want to create a field or a front end expression to filter rows in Status field.
The user should have 2 values to choose- Top, All.
When All is selected, show all products. If Top is selected show only products with status Yes.
LOAD * INLINE [
I created this filter but it is not working
if(Status = 'YES' or Status = 'NO','All',
if(Status = 'YES','Top'))
Go to Solution.
Try like this
LOAD * INLINE
Now use the filter column in the front end to get the desired results
You need to create only top filter why you require all
If top is not selected means its by default all.
If(Status = 'YES','Top') as TOP.
Please check if fits your needs
Thanks everyone for various solutions.