Add Calculated Dimensions

[#1]

I'm trying to add a "Calculated Dimension" into a Pivot Table. I have a field name called "Ontime Performance" and the values are as below:

OnTime Performance

==================

OnTime

Late

OnTime

Late

Late

Late

Late

OnTime

I would like to count only "OnTime" values from the list. What function should I use in QlikView Expression Builder?

[Gysbert_Wassenaar]

Try: sum({<[OnTime Performance]>={'OnTime'}>}1)

[er_mohit · Accepted solution]

in expression write

count({<[OnTime Performance]={'OnTime'}>}distinct [OnTime Performance])

for use only OnTime in add calculated dimension for this

pick(Match([OnTime Performance],'OnTime'),'OnTime')

[#4]

IF([OnTime Performance] = 'OnTime',COUNT([OnTime Performance]))

**************************************************************************

OR ALSO TRY THIS

IF([OnTime Performance] = 'OnTime',[OnTime Performance])