topic Re: adding extra field in QlikView

adding extra field

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

hi all,

i have loaded a file as follows

Fund Curency Value

A X 20

B Y 30

C Z 40

D P 50

I wanna added an extra field such that,in curency field i have "P",that value should b populated as a new filed,it should happn dynamicaly i.e.,

output:

Fund Curency Value Value1

A X 20 50

B Y 30 50

C Z 40 50

D P 50 50

Re: adding extra field

Anil_Babu_Samineni — Mon, 22 Jan 2018 14:39:06 GMT

Sum(TOTAL Value) will deserve

Re: adding extra field

Anil_Babu_Samineni — Mon, 22 Jan 2018 14:41:53 GMT

My bad, this will work

Sample:

LOAD * Inline [

Fund , Curency , Value

A , X , 20

B , Y , 30

C , Z , 40

D , P , 50

];

Left Join(Sample)

LOAD Max(Value) as Value1 Resident Sample;

Re: adding extra field

surendraj — Mon, 22 Jan 2018 14:56:19 GMT

load * ,if(Curency = 'P',Value) as value1 inline [

Fund, Curency , Value,

A, X , 20,

B , Y , 30,

C , Z , 40,

D , P , 50,

];

it should be

Re: adding extra field

vishsaggi — Mon, 22 Jan 2018 15:33:35 GMT

Is this Value1 should hold max value always or it should be driven by Currency?

Extending Anil's script may be try like below:

Currency:

LOAD * INLINE [

Fund, Currency, Value

A, X, 20

B, Y, 30

C, Z, 40

D, P, 50

];

LEFT JOIN(Currency)

LOAD Currency,

Sum(Value) AS Value1

Resident Currency

WHERE Currency = 'P'

Group By Currency;

Then using a straight table add

Dim: Fund, Currency, Value

Expr: = Sum(TOTAL Value1)

You can see below:

Re: adding extra field

el_aprendiz111 — Mon, 22 Jan 2018 21:29:53 GMT

Hi,

tmp:
LOAD * Inline
[
Fund,Curency,Value
A,X,20
B,Y,30
C,Z,40
D,P,50
];

MX: LOAD Max(Value) AS MxCurency Resident tmp Group By Curency;

LET vP = Peek('MxCurency');

sumary:
LOAD *, $(vP) AS Value1 Resident tmp;

TRACE $(vP);

DROP Table tmp,MX;