Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create straight table with a subset of values

Dear all,

I have a dataset that can be reproduced like this:

LOAD * INLINE [
TASK_OWNER, CODE
Henk, 1
-, 2
Piet, 1
]
;

Now I would like to create a straight table that only show the records where the TASK_OWNER has a "-" value. So I add a straight table with a calculated dimension that looks like this:

=only({<[TASK_OWNER]={'-'}>}TASK_OWNER)

1 Solution

Accepted Solutions
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

Why not just simply do like this:

LOAD * INLINE [
TASK_OWNER, CODE
Henk, 1
-, 2
Piet, 1
]

WHERE TASK_OWNER = '-'
;


Then just invoke the dimension TASK_OWNER as it is 


Hope this solve your problem...


Regards,

MB

View solution in original post

3 Replies
Anonymous
Not applicable
Author

What issue you are facing?

tresesco
MVP
MVP

Try taking CODE as dimension and then the expression as expression.

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

Why not just simply do like this:

LOAD * INLINE [
TASK_OWNER, CODE
Henk, 1
-, 2
Piet, 1
]

WHERE TASK_OWNER = '-'
;


Then just invoke the dimension TASK_OWNER as it is 


Hope this solve your problem...


Regards,

MB