Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashis
Creator III
Creator III

How to extract data

Hi ,

I have data like image below, I want to show only data that has no parents , either in load script (extract information) or in chart.

Could you please help me how to extract this peace of information.

8 Replies
tresesco
MVP
MVP

Try like:

Straight table

Dim: Sequence

Exp: If(Len(Trim(Parent1&Parent2&Parent3&Parent4))>0, JOBNAME)

ashis
Creator III
Creator III
Author

Hi  Tresesco,

Thank you for your reply. I tried your expression it is giving me following result , not the desire result.

In my data , I have time  as one column (job time) . I want to show all the jobs and its time ( as an expression) but only those jobs who has no parent.

ashis
Creator III
Creator III
Author

Thank you Tresesco, I have applied your solution except changed '>' to '=' and used in the load script . It is giving me what I want.

If(Len(Trim(Parent1&Parent2&Parent3&Parent4))=0, JOBNAME) as singlejob,

tresesco
MVP
MVP

Then try using the above expression as calculated dimension and the time field as expression.

qlikviewwizard
Master II
Master II

Hi,

Try like this.

Capture.PNG

Untitled.png

nishanthi_8
Creator
Creator

Try with where clause in the end , like where IsNull(Parent1)

qlikviewwizard
Master II
Master II

Hi ashissau,

Did you able to get the solution?

ashis
Creator III
Creator III
Author

Hi Arjun,

I created calculated dimension and used this expression to get my result.

=If(Len(Trim(Parent1&Parent2&Parent3&Parent4))=0, JOBNAME)