topic mixed data in QlikView

mixed data

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

HI All ,

PLease find my attachment of the QVW

I have a to create chart as shown in the image..

but the data is mixed parent as well as child.

For every parent ID there are multiple Child ...

I want to replsent the Chart as shown in the image ..

Is this possbile ?

I want to represnt in the way it is shown in the image

can someone please guide me over this

how do i writ the script for this......Or can be achieved at expression level .

Please need help....

THanks in Advance

Re: mixed data

avinashelite — Mon, 11 Sep 2017 07:33:03 GMT

I saw your data set how will you identify that a particular child belongs to which parent exactly ???? your files has just a list of ID saying parent and child and it doesn't state that which child belongs to which parent

Re: mixed data

andrei_delta — Mon, 11 Sep 2017 07:36:28 GMT

Hello,

Create Chart with Dimensions : ID, Type,

Expression: aggr(if(Flow='Bug',only(Flow)),ID)

i posted below the result:

Hope it helps,

Re: mixed data

smilingjohn — Mon, 11 Sep 2017 07:38:15 GMT

Hi Avinash

If u look into the ID field there is a number for the parent and whthin that only all he child should be listed ...

The ID field has id's for both parent and child ...If you look starting is the parent ID and below that there are child ID's then again it will be parent ID ...

So I want to create a table where the parent ID should for all the child I'd withing thenm

I hope u got the idea what I am trying to get ..

Re: mixed data

smilingjohn — Mon, 11 Sep 2017 07:41:49 GMT

Hi Andrei.

Look the first column should have the Parent Of listed then the second should show all the child within that parent ID and then so on....

If you look at my image of out put ..The first column has repeated ID of parent and after that the second column has child I'd 's

This is how I want to achieve

Thanks for the reply

Re: mixed data

andrei_delta — Mon, 11 Sep 2017 10:19:54 GMT

Hello again,

At the first look i thought it was a numeric date format...sorry. But, i did it! It works in script, so i'll post the script:

Distinguish:

LOAD ID,

Type,

Flow,

if(Type='Parent',ID) as ParentIDTemp

FROM

(ooxml, embedded labels, table is Sheet1)

;

Distinguish2:

NoConcatenate

Load *,

if(len(ParentIDTemp)=0, Previous(peek('ParentID')),ParentIDTemp) as ParentID

Resident Distinguish;

drop table Distinguish;

Distinguish:

NoConcatenate

Load *

Resident Distinguish2

where Type='Child';

drop Table Distinguish2;

And the result: