Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please guide me on below issue.
Firsttable:
Load *,
If(Country='India' and Region='South','First',
If(Country='Singapore' and Region='South','Second',
----------------------------------------)) as Newfield
from [lib://Qlikdev/data/facts/-----.qvd](qvd);
From the above table
I want to reuse "Newfield" data where ever I want using subroutines.
did you mean a way to lookup Newfield? you can either do a left join with a list of Country, Region, and Newfield
or do an applymap (you just need to concat Country and Region:
https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunction...