script logic

[#1]

so my requirement is if flag=ref then its refinance



and if flag=d - if flag=ref is non refinance how do i write script



both in single dimention when i get as dimention it shold have refinance and non refinance



pls help me

[#2]

It sounds like you want a field as follows:

If(FLAG='REF','Refinance','Non-Refinance')

This would show REF as Refinance and anything else as Non-Refinance.  Is that what you are looking for?

[#3]

Hai,

That is straight logic

but wt my req is if flag=ref refinanace

and if flag=d - if flag=ref as non refinance

[khadeer]

Try this

if(flag='Reference', 'Reference',if(flag='D' and flag<>Reference,'Non reference')) as Ur dimension

[jagan]

Hi Ram,

Simply create a inline table as

LOAD * INLINE [

Flag,    Category

ref, Refinance

d, Non Refinance];

or load from excel file.

Regards,

Jagan.

[#6]

sorry i am not getting

i need both shold be in dimention

y means i want to show pie chart % for both

and one more help last 8 roling quarters and eight months how do i find in the chart pls help me

[khadeer]

create inline table n join that table to ur table