Discussion Board for collaboration on QlikView Layout & Visualizations.
try this , hope this will help you
if(Region ='Unknown',dual(Region,1000),Region) as Region_new;
Load Id,Name,Login Date,countofLogins, applymap('Mappingtable',Id,'Unknown') as Region
Note:- here let us consider 1000 is the last row number of region field. you can change accordingly.
Thanks & Regards
maybe you could sort Region by expression:
hope this helps
Check this app
Use Sort by Expression for Region as Ascending with Expression below
Hope it helps
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()