Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Re: Null values needs to be sorted at last..if replaced with some value

hi

try this , hope this will help you

Mappingtable:

Mapping Load

Id,Region

from excel1;

 

Table 1:

load *,

if(Region ='Unknown',dual(Region,1000),Region) as Region_new;

Load Id,Name,Login Date,countofLogins, applymap('Mappingtable',Id,'Unknown') as Region

from excel2;

Note:- here let us consider 1000 is the last row number of region field. you can change accordingly.


Thanks & Regards

vishwaranjan

Re: Null values needs to be sorted at last..if replaced with some value

Hi,

maybe you could sort Region by expression:

Sum(If(Region='Unknown',0,countofLogins))

hope this helps

regards

Marco

Highlighted
anbu1984
Honored Contributor III

Re: Null values needs to be sorted at last..if replaced with some value

Check this app

Re: Null values needs to be sorted at last..if replaced with some value

Use Sort by Expression for Region as Ascending with Expression below

=Match(Region, 'Unknown')

Hope it helps

Celambarasan

MVP & Luminary
MVP & Luminary

Re: Null values needs to be sorted at last..if replaced with some value

With a dual-field you have both a string-part (could be a number, too) which it showed normally within the dimension and an additional numeric part. Those fields could then simply sorted as number.

Dual & Exists – Useful Functions

How to use- Dual()

- Marcus