topic To Add Calculated field on the basis of Existing fields in QlikView

To Add Calculated field on the basis of Existing fields

Mon, 08 Oct 2012 09:43:51 GMT

Hi,

I am new on Qlikview, I want to add one Calculated field on the basis of existing fields.

I have fields (1-sep , 2-Sep, 3-Sep, 4-Sep .....30-Sep)

I want to add One field (Yesterday Date) & If yesterday Date is matching with any of the Field then it should take Data of that field only.

Please help.

Thanks,

Narsingh

Fri, 19 Oct 2012 13:52:51 GMT

Help Anyone please....

MayilVahanan — Fri, 19 Oct 2012 13:57:18 GMT

Load * ,if(date(today()-1,'DD-MMM') = DateField, 1 ,0 ) as FieldName from table;

Hope that helps

Fri, 19 Oct 2012 14:06:06 GMT

Thanks for reply...

But I have Date field in Column Headers as

Name 12-Oct 13-Oct 14-Oct 15-Oct 16-Oct

A x y z p q

B p z y x q

C y x z q p

And I want Data of that Column where "Date" is Yesterday...

MayilVahanan — Fri, 19 Oct 2012 14:14:21 GMT

Try like this

crossTest:

CrossTable(CrossDate,CrossValue)

Load * Inline

[

Name,12-Oct,13-Oct,14-Oct,15-Oct,16-Oct

A,x,y,z,p,q

B,p,z,y,x,q

C,y,x,z,q,p

];

Load *, if(date(today()-1,'DD-MMM') = CrossDate, CrossValue ,0 ) as reqValue Resident crossTest;

Drop Table crossTest;

Hope that helps