The hyphen is displayed by default in a QlikView chart when the data value is null. You can change that behavior by right-clicking the chart and selecting Properties and selecting the Presentation tab. You'll see a place where you can define a null symbol and a missing symbol. I sometimes set the null symboll to the word null just to make the data issues clear.
The Statistics Box doesn't give you the kind of control you need (if I understand your question correctly) - it makes you select a field and doesn't allow you to enter an expression that would only include specified values of the field.
You could try a text object with expressions that include or exclude the data according to your requirements. For example, this text expression could be used in a text object to show information about a field named BUDGET but excluding null values:
='Total count = '&Count(total if(not isnull(BUDGET),BUDGET))&'
Sum = '&Sum(BUDGET)&'
Average = '&Round(Sum(BUDGET)/Count(if(not isnull(BUDGET),BUDGET)))&'
Min = '&min(if(not isnull(BUDGET),BUDGET))&'
Max = '&max(if(not isnull(BUDGET),BUDGET))
The If statement can be used to include or exclude any values. Use the Round function and Num functions as needed to format the data.
Thank You Tim.
Could you please write me a sample code to read a table box using Macro . I have a table box having 4 fields (Country,County,Collateral,Name)
I want to read table box for each field and check the Null values and incorrect values present for each field . If there are null values then the row should not be displayed in table box and a counter to count the total records which are not to be displayed
Country county collateral Name
USA FL Fire xyz
UK Bedford Wind ABC
et Doc = ActiveDocument
set tb = ActiveDocument.Sheets("Main").SheetObjects("TB01")
set fld = tb.GetField(1)
For r = 1 to tb.GetRowCount-1
set cell = tb.GetCell(r,2)
if cell is null or len(cell)<6 then
//statement to remove the record from table box.
set counter1 = counter1+1
But the variable Cell is not holding the field value (USA). Please help me to read the content of each field in table box until end of the records.