Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ashissau
Contributor II

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
MVP
MVP

Re: How to extract data

Try like:

Straight table

Dim: Sequence

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

ashissau
Contributor II

Re: How to extract data

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.

ashissau
Contributor II

Re: How to extract data

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,

MVP
MVP

Re: How to extract data

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

Arjunarao
Honored Contributor II

Re: How to extract data

Hi,

Try like this.

Capture.PNG

Untitled.png

nishanthi_8
Contributor

Re: How to extract data

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

Arjunarao
Honored Contributor II

Re: How to extract data

Hi ashissau,

Did you able to get the solution?

ashissau
Contributor II

Re: How to extract data

Hi Arjun,

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

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

Community Browser