Count query

[#1]

Hi guys,
I hope someone can help.

I have a seemingly basic query where I wish to count the number of records from our ODBC database where field name pova = 0 , where fields crbrenh,crbrbasic & crbrenh are NULL and where employstatus <> 999001302

I have tried various different coding but it does not return what I know to be correct. I have put the fields into a table to see what I am looking at and the fields crbrenh,crbrbasic & crbrenh appear to be a mixture of blanks and - so I suspect this is part or all of the problem.

Any ideas?

Thanks,

Matt

[Miguel_Angel_Baeyens]

cayfmatt wrote:I have to say, as a complete beginner, Qlikview can be extremely frustrating (especially when you do not save before Edit Script and if it doesnt work & comes back with an error, you lose all of your changes!

Agree. Fortunately, there are some good settings to check in QlikView. Go to the Settings menu, User Preferences, and tab "Save". Click on "Save before reload" and set the others as you wish. All these settings are documented in the Reference Manual available in the Dowloads section above as well as when you install QlikView choosing "Complete Install".

Hope this helps!

[#3]

Thanks Sebastian and Miguel.

Miguel - I have been getting the employstatus from another section of coding within Edit Script but didnt want to paste it all in. I'm now down to about 22 'wrong' records from over 200 before so thanks again, I'll continue playing around with it (also now enabled the auto save function )