Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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