topic Re: Create 3 subsets (table from Original Table) in QlikView

Create 3 subsets (table from Original Table)

Wed, 04 Jan 2017 08:40:32 GMT

Hi Team,

Can you please guide me How can I create 3 subsets (tables using Where Clause) from parent table...

I am finding difficulty in using Where clause

Say I have a table named Original

Say it has a field named Status and Say Status has Value like Unresolved, Resolved and Delete

How I can create 3 subsets of tables , Table 1 where Status ='Resolved'

Table 2 where Status ='Unresolved'

Table 3 where Status ='Deleted

I have my Script for Original table as

Original:

LOAD Id, FileDate,

Status,

FROM

(ooxml, embedded labels);

Regards

Siddharth

Re: Create 3 subsets (table from Original Table)

MK_QSL — Wed, 04 Jan 2017 08:51:59 GMT

Original:

LOAD Id, FileDate,

Status,

FROM

(ooxml, embedded labels);

NoConcatenate

T1:
Load * Resident Original Where Status = 'Resolved';

Store T1 into T1.qvd(QVD);

NoConcatenate

T2:
Load * Resident Original Where Status = 'Unresolved';

Store T2 into T2.qvd(QVD);

NoConcatenate

T2:
Load * Resident Original Where Status = 'Deleted';

Store T3 into T3.qvd(QVD);

Drop Table Original;

===============================

I am assuming that you want to create 3 different QVDs.

If you don't want to do this... what is the reason you want to have three different tables with different status?

Re: Create 3 subsets (table from Original Table)

Wed, 04 Jan 2017 09:19:53 GMT

Thanks Manish,

Yes you are right, I was thinking of joining them so that I can have Date open(from Table 2) and Date Close(Table) in One New Table, and then May be it is easier for me to calculate Cycle Time

Can you guide me with better alternate, as there are Ids can be in Unresolved status for may dates..eg

Id Error Date Status

A 1 12/1/2016 Unreolved

A 1 12/2/2016 Unresolved

A 1 12/3/2016 Unresolved

A 1 12/5/2016 Resolved

and I need to find average Cycle time, Best part is I also need to create aging(if Status remain Open )

Regards

Siddharth

Re: Create 3 subsets (table from Original Table)

Wed, 04 Jan 2017 09:30:16 GMT

Hi Manish,

When I am trying to draw table from T1, Due to synthetic Keys, I am getting all the entries apart from Resolved status.

I was thinking of using a complete join between Table T 1 and T2

Regards

Siddharth