Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Straight table - limit selection

Hi guys,

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

Item ID
QtySalesCost
Total1010050
GEF55025
ABCABC32010
123456723015

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?

Thanks!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Straight table - limit selection

Create a calculated dimension if(len([Item ID]>5,[Item ID]) and check the option Suppress When Value Is Null


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Straight table - limit selection

Create a calculated dimension if(len([Item ID]>5,[Item ID]) and check the option Suppress When Value Is Null


talk is cheap, supply exceeds demand
Not applicable

Re: Straight table - limit selection

THANKS!