If Then Question

Mon, 18 Mar 2013 16:44:40 GMT

I have the following data in Excel that I want to Load into Qlikview

Order Operation Value

12345 0060 3

12345 0061 5

12346 0060 10

12347 0060 5

12347 0061 11

What I am trying to do is have it load everything that has 0060 with its order and value, but if it has an 0061 I want the value from it and not from 0060. What is the best way to do that?

thanks for your help

Marcia

Re: If Then Question

hic — Mon, 18 Mar 2013 17:05:46 GMT

I would probably do it like

Temp:

Load Order as TempOrder, Operation, Value From <Data> ;

Final:

Load TempOrder as Order, Operation, Value

resident Temp

Where not Exists(Order, TempOrder)

Order By Operation Desc;

Drop Table Temp;

HIC

topic If Then Question in QlikView

If Then Question

Re: If Then Question