Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
You might have better luck posting this in the New to Qlik Sense arena.
please post a sample.
may this is helpful
//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;