topic Creating a flag field from two separate QVD in App Development

Creating a flag field from two separate QVD

mikegauntlett — Sat, 02 Sep 2017 12:36:12 GMT

Hi All,

In short I have two fields 'country' from a country.QVD and 'order_booked' from orders.QVD.

They are in two differing sections of the load script

Want I want to be able to get to, is to create a flag field

When 'Country'=UK and 'Order_booking'='false'.

Everytime I try if(country='UK',if(Order_Booked='false',1,0),0) as uknotbookedflag

when loading the data it states that one or the other field does not exist.

Any Ideas

thought i would add the actual script

Message was edited by: Michael Gauntlett adding in script

Re: Creating a flag field from two separate QVD

sunny_talwar — Sat, 02 Sep 2017 15:59:02 GMT

You will have to bring the two tables into a single table either using a join or Lookup or ApplyMap and then do the if statement you are looking to do

Re: Creating a flag field from two separate QVD

mikegauntlett — Sat, 02 Sep 2017 16:39:40 GMT

HI sunny

How do those methods work, sorry new to qliksense.

What is the syntaxes for the apply map function