topic Re: Add Calculated Dimensions in QlikView

Add Calculated Dimensions

Wed, 01 May 2013 11:42:44 GMT

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

OnTime

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

Gysbert_Wassenaar — Wed, 01 May 2013 11:48:34 GMT

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

er_mohit — Wed, 01 May 2013 12:01:51 GMT

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')

Wed, 01 May 2013 12:23:18 GMT

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

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

OR ALSO TRY THIS

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