Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a dimension within a straight table that excludes multiple values. Specifically, I am trying to filter out about 20 different Test Patients from a set of data.
Is it possible to create a calculated dimension within the straight table that will filter them out, or must this be done a different way?
Keep in mind, I need them to load into the application for other tables.
Hi
Try like this,
if(not match(FieldName,'value1','value2',..,'value20'),FieldName) as dimension and suppress null value..
or
if excluded field value is more then displaying field value means, use match function as per your convenience..
Hope it helps
You can use a calculated dimension and suppress nulls. See attached for a basic example.
Hi
Try like this,
if(not match(FieldName,'value1','value2',..,'value20'),FieldName) as dimension and suppress null value..
or
if excluded field value is more then displaying field value means, use match function as per your convenience..
Hope it helps
The if(not match ...) worked well, thank you.
Hai Mayli
What Is The Meaning Of Uni Testing In QLikview.