AND-MODE script fix request

[#1]

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

[Anonymous · Accepted solution]

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;

[#3]

many thanks, Dennis

how to contact you?

[Anonymous]

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