topic Re: Calculated Field in QlikView

Calculated Field

vardhancse — Mon, 14 Jul 2014 17:57:17 GMT

Hi,

Have a requirement is that, need to create one field based on if condition.

Can any one let me know

Re: Calculated Field

Mon, 14 Jul 2014 18:03:49 GMT

Hi,

Just create a list box, go to "General" sheet, find and open Field Combo Box and select "Expression" at the end of list, then you have to tip something like this:

If (Condition 1,

Result1,

Oposite Result

)

Example I need 1 if Sex Value is Male and 2 if is Female so I use:

If(Sex='Male',

)

and if I have nulls I can use:

If( Sex = 'Male',

If(Sex='Female',

0 // To identify nulls values

)

Best regards.

Re: Calculated Field

pgrenier — Mon, 14 Jul 2014 18:53:37 GMT

Hello Sasi,

Could you be more specific? Otherwise, you might want to check QlikView's help function by hitting the F1 key and entering "If" in the Index field.

Regards,

Philippe

Re: Calculated Field

its_anandrjs — Mon, 14 Jul 2014 19:05:22 GMT

Yes possible but please elaborate more which type of field or what condition you want to create the field.

Re: Calculated Field

vardhancse — Tue, 15 Jul 2014 13:28:57 GMT

requirement is that

in chart has written set analysis as =sum({<[Time]={'$(vMaxDate)'}>}[Field])

Let vMaxDate=MAx(Time)

sum(if(max(Time),(Field)) as Count