How to avoid the NA

[manoranjan_d]

Hi

In the bar chart dimension i want to avoid the null and NA value, For Null I can select the suppress null value  option, but for NA how to do that in a dimension, what is condition for this? i have attache the file

[Anonymous]

Replace your Dimension with this?

If(DimName<>'NA', DimName)

[mayankraoka]

Attached Qvw for ur solution.

[amit_saini]

Hi,

Can be done in 2 ways:

1. Script Side:

LOAD dept,

     presentabsent,

     student,

     amount,

     SECTION

FROM

(ooxml, embedded labels, table is Sheet1)

where dept <>'NA';

2. Layout side:  Check yellow marked condition

Thanks,

AS