i want to ask that how to remove null values??

[divyanshi]

For example if we apply join between two tables in qilksense only then null values appear in "-" (dash) form.

As a result, in pivot table it makes a separate column which has a column header represented by "-" symbol and include all '-' values.

Can anyone solve this problem ?

[johnca]

You might have better luck posting this in the New to Qlik Sense arena.

[Anonymous]

please post a sample.

[ziadm · Accepted solution]

may this is helpful

Don't join - use Applymap instead

[ziadm]

//This is an example of map using  and map the field Region to Unknown as a result of left join

MapNulls:

Mapping LOAD

null(), Unknown

AUTOGENERATE 1;

Map Region using MapNulls;

Temp:

LOAD * inline [

Customer|Product|OrderNumber|UnitSales|CustomerID

Astrida|AA|1|10|1

Astrida|AA|7|18|1

Astrida|BB|4|9|1

Astrida|CC|6|2|1

Betacab|AA|5|4|2

Betacab|BB|2|5|2

Betacab|DD|12|25|2

Canutility|AA|3|8|3

Canutility|CC|13|19|3

Divadip|AA|9|16|4

Divadip|AA|10|16|4

Divadip|DD|11|10|4

Divadip|DD|11|10|4

] (delimiter is '|');

left join

load * inline [

CustomerID, Region

1,TX

2,CA

];

NoConcatenate

Temp1:

load *,

if(Len(Region) = 0,null(),Region)

Resident Temp;

drop Table Temp;