Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add Calculated Dimensions

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?

1 Solution

Accepted Solutions
er_mohit
Master II
Master II

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


View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
er_mohit
Master II
Master II

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


Not applicable
Author

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

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

OR ALSO TRY THIS

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