I have two tables:
They are linked by CustomerId
. Currently, I display both the tables on a sheet in Qlik and on selection of the CustomerId
in the first table, the values in the second table are updated.
However I would like to start with an empty second table and fill it in/populate the table only on the selection of CustomerId in the first table. How can I do this?
You can't actually have trigger on something being selected in specific table/chart but since selecting in chart actually is making a selection then you can have calculation conditions based on the selected value(s).
When chart properties a open you can have calculation condition. For example:
= GetSelectedCount("CustomerId") = 1
You can overwrite the default error message by specifying the text in Caclulation condiction unfulfilled
section:
(Just to mention that the message can be an expression as well)
The situation with Sense is similar:
Add-ons
Data handling
Displayed message
input will appead