Wildmatch, wildcard, load statements

Mon, 22 Aug 2011 18:34:09 GMT

Hi,

I am trying to create a table which shows regular orders and back orders.

The distinction in my data is the last digit of the order reference.

For example all orders ending in .0 (242.0, 323.0) are the originals, and any orders that end in a digit >0 are the back orders (242.1, 323.6)

How do you suggest i go about splitting the two type of orders? For this example, say i want to sum sales of regular orders and compare it to back orders

I thought of using the wildmatch function or making the distinction in the load but i can't figure out a way to make it work.

Any suggestions please

Wildmatch, wildcard, load statements

swuehl — Mon, 22 Aug 2011 18:51:05 GMT

I would also add a flag to the table in the load script, maybe:

if(num(right(text(OrderRef),1))>0,'backorder','original') as OrderType,

topic Wildmatch, wildcard, load statements in QlikView

Wildmatch, wildcard, load statements

Wildmatch, wildcard, load statements