topic Re: How to extract data in QlikView

How to extract data

ashis — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to extract data

tresB — Tue, 10 Jul 2018 05:43:55 GMT

Try like:

Straight table

Dim: Sequence

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

Re: How to extract data

ashis — Tue, 10 Jul 2018 05:52:50 GMT

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.

Re: How to extract data

ashis — Tue, 10 Jul 2018 06:05:09 GMT

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,

Re: How to extract data

tresB — Tue, 10 Jul 2018 06:05:24 GMT

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

Re: How to extract data

qlikviewwizard — Tue, 10 Jul 2018 06:13:41 GMT

Hi,

Try like this.

Re: How to extract data

nishanthi_8 — Tue, 10 Jul 2018 06:23:28 GMT

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

Re: How to extract data

qlikviewwizard — Wed, 11 Jul 2018 06:13:45 GMT

Hi ashissau,

Did you able to get the solution?

Re: How to extract data

ashis — Thu, 12 Jul 2018 04:41:06 GMT

Hi Arjun,

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

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