topic Re: AND-MODE script fix request in QlikView

AND-MODE script fix request

Sun, 19 Jan 2014 23:04:08 GMT

This request clarifies a previous post, titled "AND_MODE help request".

In the Script TAB, titled "AND" of the attached 011914 Times Square.qvw...

...can any fix or replace the AND-MODE script, appearing between lines 11-19, with script that enables the andRestaurant field, appearing in the Model TAB2, to work?

many thanks,

morganstern

Re: AND-MODE script fix request

Anonymous — Mon, 20 Jan 2014 11:57:46 GMT

What you are trying to with this....

Load Item, Food Resident [Applebee Menu];

Join (andModeJoin) Load Item, Restaurant Resident POS;

is to connect the Food and the Restaurant by using your item field.

But your Item field is not connected when it comes restaurent TGIF.

If you want an And-Mode which connect the Costumers and the Restaurant (Is that what you want?) you can try something like:

andModeJoin:

Load Customer,

Restaurant

Resident POS;

andMode:

Load Distinct

Customer,

Restaurant as andRestaurant

Resident andModeJoin;

DROP Table andModeJoin;

Re: AND-MODE script fix request

Mon, 20 Jan 2014 17:53:08 GMT

many thanks, Dennis

how to contact you?

Re: AND-MODE script fix request

Anonymous — Tue, 21 Jan 2014 16:05:25 GMT

Glad I could help. If you have any question let me know.

You can contact me here by adding me as a friend.

Or else through www.Qlikviewspecialist.nl