How to extract data

[ashis]

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.

[tresesco]

Try like:

Straight table

Dim: Sequence

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

[ashis]

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]

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]

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

[qlikviewwizard]

Hi,

Try like this.

[nishanthi_8]

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

[qlikviewwizard]

Hi ashissau,

Did you able to get the solution?

[ashis]

Hi Arjun,

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

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