topic Re: Grouping in QlikView

Grouping

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Have a field name "Runs" and the values under it are like this

0.01

0.2

.06

.09

4.0

In the script i want to derive one more column from this where the condition is

if(Runs>=0.01 and <=0.9 'Low'

if(Runs=>0.9 and <= 2 'middle'

if(Runs=>2 'High') as Consolidate

How do i achieve this in the script level

Can someone help me please

sunny_talwar — Thu, 17 Mar 2016 10:51:08 GMT

Something like this:

Table:

LOAD Runs,

If(Runs>=0.01 and Runs <=0.9, 'Low', If(Runs >= 0.9 and Runs <= 2, 'Middle', 'High')) as Consolidate;

LOAD * Inline [

Runs

0.01

0.2

.06

.09

4.0

];

its_anandrjs — Thu, 17 Mar 2016 10:52:45 GMT

Try this ways

if(Runs >= 0.01 and Runs <= 0.9 ,'Low',

if(Runs => 0.9 and Runs <= 2 , 'middle',

if(Runs => 2, 'High' ) as Consolidate

Regards,

Anand

Chanty4u — Thu, 17 Mar 2016 10:55:29 GMT

chk below