QlikView AccessPoint: How to return specific set of records onlyi

[Anonymous]

How to return only specific set of records say for example only blank values for the column? What should be the syntax for expression? Thanks

[devarasu07 · Accepted solution]

Hi,

Let's you have dimension as Country with null and Sales Value.

to display only null country sales then  u can try like this

2) Using Calculated Country Dimension: // suppress null value on this cal.dimension

if( len(trim(Country))=0, Country,0) 

and Measure as Sum(Sales)

2) Using Set analysis method,

sum( {<Country={"=len(trim(Country))=0"}>} Sales)

3) using back end script,

load * from fact where len(trim(Country))=0;

Thanks,

Deva