Discussion board where members can get started with QlikView.
I have a simple query(though I' am not getting it right)...I have a table in which there are certain fields where in some cases their respective attributes are apparing as '-' (hyphen)
Now in that way my count of policy is appearing more than it is in actual, as I' am writing count(distinct Pol_ID)
i have tried there various options like...suppress where the value is null etc etc.. but it's not working
kindly help out
In Chart properties, the Presentation tab, Lower left corner there are two fields: NULL SYmbol and Missing Symbol. Clear out the - in there.
Is it possible for you to share the document?
I m done with it...thanks