Discussion Board for collaboration related to QlikView App Development.
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.
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"
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