Discussion board where members can get started with QlikView.
Hi Have Created a Pie Chart.
There i have 4 catogiries and one catogory is null.
I want to display all catogories in the chart.
So in my legend the null value shows as "-".
I need to rename that value as "NOT Recived".
Please help me to do this.
Go to Solution.
Find the attached application,you will get an idea.
if category contains all categories the 5 you write in the expression
if(catogory ='-', 'NOT Recived',catogory)
if category only contains '-' write
if(catogory ='-', 'NOT Recived')
please tell me where to put that expression in PIe chart.
my four catogories are,
Recive with Accept
Recived with reject
Recived with Data Change
Ricived with Errors
and "-" - I want to display this as "NOt Recived"
which are your dimension and you expression??
Hi This works fine , Thanks.
But There is a Problem.
I can't clik on "NOt Recived" are and filler the data.
Try in script, then
You need that one chart or more than that, if more than one means,
Load *, if(isnull(FieldName)=-1,'NotReceived',FieldName) as FieldName from tablename;
Hope it helps