topic Bandwidth Inline in QlikView

Bandwidth Inline

krishna20 — Wed, 26 Nov 2014 10:33:33 GMT

Hi friends,

Below is my expression.I want to load this expression in Load or Inline Table.

if(AMOUNT<0 ,Dual('<0',1),

if(AMOUNT>1 and AMOUNT<=500000,Dual('1-500,000',2),

if(AMOUNT>=500001 and AMOUNT<=1000000,Dual('500,001-1,000,000',3),

if(AMOUNT>=1000001 and AMOUNT<=2000000,Dual('1,000,001-2,000,000',4),

if(AMOUNT>=2000001 and AMOUNT<=5000000,Dual('2,000,001-5,000,000',5),

if(AMOUNT>=5000001 and AMOUNT<=10000000,Dual('5,000,001-10,000,000',6),

if(AMOUNT>10000000,Dual('Above 10,000,000',7))))))))

Please find the below attachments.

Error_band Image shows what I'm getting and Correct_Band shows what i need.Please anyone can help me out.

Regards

Krishna

Re: Bandwidth Inline

ashfaq_haseeb — Wed, 26 Nov 2014 10:40:02 GMT

Hi,

This could mean that you don't have values for AMOUNT less then 0.

Regards

ASHFAQ

Re: Bandwidth Inline

krishna20 — Wed, 26 Nov 2014 10:44:14 GMT

Hi Ali,

I Need to show this expression as a field.I'm having values below zero.The above Error_band Image (Expression) i implemented in Editor Script and Correct_Band (Expression) implemented in List Box Expression.

Regards

Krishna

Re: Bandwidth Inline

ashfaq_haseeb — Wed, 26 Nov 2014 11:17:32 GMT

It will not work with inline take this code to proper table.

Regards

ASHFAQ

Re: Bandwidth Inline

its_anandrjs — Wed, 26 Nov 2014 11:22:39 GMT

Hi,

In any resident load this is possible

Load

if(AMOUNT<0 ,Dual('<0',1),

if(AMOUNT>1 and AMOUNT<=500000,Dual('1-500,000',2),

if(AMOUNT>=500001 and AMOUNT<=1000000,Dual('500,001-1,000,000',3),

if(AMOUNT>=1000001 and AMOUNT<=2000000,Dual('1,000,001-2,000,000',4),

if(AMOUNT>=2000001 and AMOUNT<=5000000,Dual('2,000,001-5,000,000',5),

if(AMOUNT>=5000001 and AMOUNT<=10000000,Dual('5,000,001-10,000,000',6),

if(AMOUNT>10000000,Dual('Above 10,000,000',7)))))))) as NewField

Resident TableName;

But inline is not possible.

Regards

Anand