topic Re: script logic in QlikView

script logic

Fri, 04 Jan 2013 12:40:03 GMT

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

Re: script logic

Fri, 04 Jan 2013 21:02:27 GMT

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?

Re: script logic

Sat, 05 Jan 2013 03:54:27 GMT

Hai,

That is straight logic

but wt my req is if flag=ref refinanace

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

Re: script logic

khadeer — Sat, 05 Jan 2013 04:36:37 GMT

Try this

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

Re: script logic

jagan — Sat, 05 Jan 2013 08:28:44 GMT

Hi Ram,

Simply create a inline table as

LOAD * INLINE [

Flag, Category

ref, Refinance

d, Non Refinance];

or load from excel file.

Regards,

Jagan.

Re: script logic

Sat, 05 Jan 2013 08:37:21 GMT

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

Re: script logic

khadeer — Sat, 05 Jan 2013 08:49:25 GMT

create inline table n join that table to ur table