Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AND-MODE script fix request

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

1 Solution

Accepted Solutions
dennisnet
Partner
Partner

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;

View solution in original post

3 Replies
dennisnet
Partner
Partner

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;

View solution in original post

Not applicable
Author

many thanks, Dennis

how to contact you?

dennisnet
Partner
Partner

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