topic Re: Faceing Problem with Subfield in QlikView

Faceing Problem with Subfield

jagannalla — Mon, 25 Jul 2011 07:57:46 GMT

Hi,

I've a variable vTotal= GoodReads,MissingReads,NoReads

Now by using subfield i'm dividing GoodReads,MissingReads,NoReads in seperate variables i.e vA=SubField(vTotal,',',1)

vB=SubField(vTotal,',',1)

When i using this variables in edti script i'm not able load qvd file error

- The script is like this

LOAD

Total

where (Total='$(vA)');

LOAD

RowNo()as Sno,

if(Total='No Read','NoReads',if(Len(CTCateg)>0,'GoodReads','MissingReads'))as Total,

From Table1.qvd;

Re: Faceing Problem with Subfield

lironbaram — Mon, 25 Jul 2011 08:44:11 GMT

hei

try this script

let vTotal= 'GoodReads,MissingReads,NoReads';

LET vA=SubField(vTotal,',',1) ;

Let vB=SubField(vTotal,',',2);

LET vC=SubField(vTotal,',',3);

LOAD
B,
Total

where (Total='$(vA)');
LOAD * INLINE [
    Total, B
    GoodReads, 11
    MissingReads, 12
    NoReads, 14
    GoodReads, 24
    MissingReads, 56
    NoReads, 67
];

Faceing Problem with Subfield

jagannalla — Mon, 25 Jul 2011 09:00:50 GMT

Thanks liron baram...it's working