It's a common mistake. The equals sign after Contacts doesn't mean what you think it does, it's more of a Set descriptor than an actual formula equal sign.
It's a common mistake. The equals sign after Contacts doesn't mean what you think it does, it's more of a Set descriptor than an actual formula equal sign.
NMiller's set description should do the trick. To explain what is going on further, the dollar sign (which is optional) says to start with the current selections. Then his set description says to modify the current selections by ignoring whatever is currently selected for Answerphone, and instead pretending that all non-0 values have been selected. As for the rest, distinct is there in case you have duplicate Account_Keys. Normally each occurrence would be counted, but distinct says to only count each Account_Key once.
Oops! Sorry, didn't notice the single quotes instead of double quotes. Single quotes is a literal, so you're looking for the literal <> 0. Double quotes is a search string, which is what you need here. You need to search for everything <> 0. So probably this:
I retract my below accusation that Qlikview was lying to me.. Infact it was user error.
I forgot the field names are case sensitive.
------------------
Now I think its lying to me.
My graph has 2 using same code as above. One has the Line style with Full Accumulation and the Other the bar chart style with no accumulation.
The bar chart was not showing so as a test I set it to full accumulation. Now an exact match to my line only a bar chart and not line.. This produced no difference in the visual outcome.
However its almost 4 hours past my shift end so im considering giving up on this for tonight.
