Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Master-table for plant_selection - how to ?

Hi,

in one of my apps (a management_dashboard), I have the following issue:

- We have four plants

- Management should be able to review the KPIs for either one(or several) of our plants or the overall

<=> The data, in some of my data_sources, is available for only three of the four plants

=> This means that if I do generate a master_table which is linked to different data_sources, only three plants will be selectable.

<=> How can I handle this issue?

  (I think I have found a way, by implementing a sheet_level trigger, to select on one plant_field the same value as on another
    plant_field; Now, when the user selects the plant (from one data_source) that is not available in the other source, nothing
    happens.

    <=> That works only if exactly one plant is selected; If the user selects two (by holding down the Ctrl key), it doesn't work.

Can somebody help me there? I guess that there's no easy way of doing this? Rather than make things too complicated here, I'd just write in a comment that the user should not do that.

Thanks a lot!

Best regards,

DataNibbler

0 Replies