spc a count IF expression

[qliklizzy]

Hi

Can you carry out an average / SPC / deviation expressions on a count if expression?

I have this formula which flags whether that data item was a cancellation or not, and then I can count all the 1's to show this against the activity.

count(if(match(CancelledOnDay,'1'),'1') )

However I want now add a SPC due to some process changes to see whether it will impact on cancellations and improve on activity

I have followed the instruction I found on here on how to do SPC in Qlikview but as my field isn't a fields its a count if expression - I cant seem to get it to work>?

Is there any way I can?

thanks in advance for taking a look

Liz x

[qliklizzy]

This works! thanks so much

I have done it using weekyear dimension as it was a bit much per day - definitely done the job!

now to work on st dev, and upper and lower limits.

I'm made up, thanks

Liz x