topic How to Exclude other Field Values within same Fieldname? in QlikView

How to Exclude other Field Values within same Fieldname?

Mon, 30 Mar 2015 09:55:01 GMT

Hi All,

How do i Assign or Exclude New Fields like Below:

Code as Frm,

if(Code>4,Code) as To,

Output:

Frm,

To,

Gysbert_Wassenaar — Mon, 30 Mar 2015 09:57:50 GMT

Data:

LOAD

if(Frm<=4,Frm) as Frm,

if(Frm>4,Frm) as To

FROM ....

PrashantSangle — Mon, 30 Mar 2015 09:58:33 GMT

Hi,

try like

load

if(code=4,Code) as Frm,

if(code>4,Code) as To

from table;