Discussion board where members can get started with QlikView.
Thanks for looking!
I have a straight table where I would like to only show those items that have string lenth of more than 5.
For example, now I have
I would like to exlude "GEF" from this stragiht table.
How can I do this?
I found a way to exclude it by adding a len(Item ID) column to my load statement and exluding all short items IDs in a list box.
However this way my current selections box gets "dirty" with selections that I don't want to show to the end User.
Is there a better way to limit raw data provided for straight table output?
Go to Solution.
Create a calculated dimension if(len([Item ID]>5,[Item ID]) and check the option Suppress When Value Is Null