topic Reuse field data using Subroutines in App Development

Reuse field data using Subroutines

venkatqlik_411 — Thu, 24 Jun 2021 11:26:03 GMT

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.

edwin — Fri, 25 Jun 2021 20:18:00 GMT

did you mean a way to lookup Newfield? you can either do a left join with a list of Country, Region, and Newfield