Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

How to Exclude other Field Values within same Fieldname?

Hi All,

How do i Assign or Exclude New Fields  like Below:

Code  as Frm,

if(Code>4,Code) as To,

Output:

Frm,

4,



To,

5,

6,

7,

8

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to Exclude other Field Values within same Fieldname?

Data:

LOAD

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

     if(Frm>4,Frm) as To

FROM ....


talk is cheap, supply exceeds demand

Re: How to Exclude other Field Values within same Fieldname?

Hi,

try like

load

if(code=4,Code) as Frm,

if(code>4,Code) as To

from table;

Great dreamer's dreams never fulfilled, they are always transcended.