topic Re: Expression. in QlikView

Expression.

deepakqlikview_123 — Mon, 30 Jun 2014 06:36:39 GMT

Hi All,

Below is expression that I have used previously for calculating Max years vehicle number

count( {$<Year= {$(=Max(Year))}>} VehicleSerialNumber)

But now i have changed Year to Billing_Year1.

Can you please suggest what would be expression in this case.Because my expression is not working fine.

Thanks,

Mon, 30 Jun 2014 06:38:24 GMT

Count({<Billing_Year1={$(=Max(Billing_Year1))}>}VehicleSearialNumber)

jagan — Mon, 30 Jun 2014 06:40:42 GMT

Hi,

Can you explain in detail with some sample file? If you are changing field name Year to Billing_Year1 then use this

=count( {$<Billing_Year1= {$(=Max(Billing_Year1))}>} VehicleSerialNumber)

Regards,

Jagan.

Mon, 30 Jun 2014 06:52:01 GMT

If you are using Billing_Year1 field for year then you can use this

=Count({<Billing_Year1={$(VMaxYear)}>}VehicleSerialNumber)

Variable:

VMaxYear= Max(Billing_Year1)

Still you are not getting the proper output. Attach the sample file

Regards

Nirmal