0

I have two tables:

enter image description here

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?

user42
  • 871
  • 1
  • 10
  • 28

1 Answers1

2

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).

Qlikview

When chart properties a open you can have calculation condition. For example: = GetSelectedCount("CustomerId") = 1

Chart properties

You can overwrite the default error message by specifying the text in Caclulation condiction unfulfilled section:

Custom error messages

(Just to mention that the message can be an expression as well)

Qlik Sense

The situation with Sense is similar:

  • select the chart
  • expand Add-ons
  • expand Data handling
  • Add the calculation condition
  • once the calc condition is added the Displayed message input will appead
  • enter some message in it to overwrite the default one

Qlik Sense

Stefan Stoichev
  • 4,615
  • 3
  • 31
  • 51
  • This worked perfectly, thank you! Do you have any resources that you recommend to learn Qlik? – user42 Jan 26 '22 at 15:43
  • 1
    Know there are some good books and videos available on PacktPub, so probably you can start from there. Ive started working with Qlik long time ago so personally havent checked the books/videos but know the guys that have written them – Stefan Stoichev Jan 26 '22 at 19:19