topic Re: How to create an identical table with restricted selected lines? in QlikView

How to create an identical table with restricted selected lines?

Mon, 09 Nov 2015 10:06:11 GMT

Hello,

I have a table like this, where the Planned quantity and the Delivered quantity are expressions:

I would like to do another table, identical to this one, but only select the lines where the Delivered quantity = 0

For example, my new table would contain only the last line of this example:

Order	Planned	Delivered
3	150	0

How can i do this please?

Thanks,

Regards,

Loïc

swuehl — Mon, 09 Nov 2015 10:14:34 GMT

Add this to your LOAD script:

NOCONCATENATE LOAD

LOAD Order,

Planned,

Delivered

RESIDENT YourTable

WHERE Delivered = 0;

DROP TABLE YourTable;

Anonymous — Mon, 09 Nov 2015 10:14:39 GMT

You can take a resident of same Table like

Load

Resident TableName where Order='3';

Use noconcatenate as it will automatically concat it and rename the fields name as well...

You can use Qualify/Unqualify as well for renaming

Anonymous — Mon, 09 Nov 2015 10:15:42 GMT

What are you Planned and Delivered expressions ?

Mon, 09 Nov 2015 10:15:57 GMT

Thanks for your reply.

I know this would work but i would prefer to do this outside of the script cause the amount of lines is huge...

Anonymous — Mon, 09 Nov 2015 10:17:47 GMT

Outside the script means?

if you want to use in QV, then it should be in QV...

swuehl — Mon, 09 Nov 2015 10:23:52 GMT

If order is your dimension then you try these two expression:

Planned:

=If( YourOriginalDeliveredExpressionComesHere = 0, YourOriginalPlannedExpressionComesHere, 0)

Delivered:

and enable 'suppress zero values' on presentation tab