topic Re: Multibox expression in QlikView

Multibox expression

Wed, 24 Aug 2016 10:30:16 GMT

I have two table with almost identical fields, one table has Meter details, including the meter serial number for example, I have an id field as well, which I use to link to the meter readings table. They have various fields(locations, meter types) with the same names so I use aliases. In one Table I need to give the details of the meters and in the other the meter readings, then we can start doing comparisons on the percentage of meter read during a month.

My questions is how do I link the two fields in the Multibox for selections. Hope this makes sense.

Re: Multibox expression

avinashelite — Wed, 24 Aug 2016 11:04:44 GMT

could you please illustrate your requirement with the sample data set and the required output so that we could understand the same

Re: Multibox expression

robert_mika — Wed, 24 Aug 2016 11:15:44 GMT

If there is an unique id in both tables they should work "out of the box".

As Avinash mention , you can post a screenshot of your data or model.

Re: Multibox expression

Wed, 24 Aug 2016 12:19:49 GMT

I thought of doing the screenshots, but when testing it worked actually, the situation is

Two tables

1 with Township called Township, other table has Township field named MRTownship

On Selection Multibox if I select Township the selection is made on Table1 and it pulls through on Table2 as well because I linked the two table with a Meter number, it seems to work, on the meter reading side(table 2 I just have to hide records there the readingdate or period is null, so in effect hiding record where there is no meter reading