Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hello,
If my understanding is correct, you have 3 different tables that have 3 different fields and you would like to select the same dates on all fields so all the tables will filter the same data. There might be a different solution available for your use cases scenario, however I was able to natively achieve a similar outcome by following the steps below:
1. I have loaded demo data using Data load editor:
2. After that I have created the tables:
As you can see, selecting one value from the table 1 will not affect other values on the other tables. However, you want them to be affected and to apply the same selection range on them.
3. I have created a Filter pane and added the "Year" field as dimension.
Having this object, I will be able to select the desired values of the field "Year" and then apply the same selections on the other needed fields.
4. Therefore, I have created a button and added 3 actions with action set to "Select values in a field":
5. Now you can add the expression =Replace(GetFieldSelections(Year), ', ', '; ') on all actions under "Value" and for "Field" you have to select Year_Prime, Year_Surv and Year_Effect respectively.
6. After that, just select the values from the Filter pane that you want to apply and click on the button. The actions will transfer all your selections to the other fields automatically.
UPDATE:
You can also take a look in the Qlik Developer [1] page, where you can find extensions to achieve specific use case scenarios. For example, there is an extension E-mergo Triggers [2], which, according to the description, allows you to trigger actions based on changes in field selections. So you can add this extension to your app and then add the same actions described above, when the Year's field selections changes. This will allow you to avoid having the user to click on the button to apply the selections.
NOTE: Please keep in mind that there might be other extension available as well, however if you have any issues with how to use them or if there are any unexpected behavior, you will have to reach to the individual developers as those extension are not created by Qlik.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
[1] https://developer.qlik.com/
[2] https://developer.qlik.com/garden/5f5baa89773702001909d838
Hello,
If my understanding is correct, you have 3 different tables that have 3 different fields and you would like to select the same dates on all fields so all the tables will filter the same data. There might be a different solution available for your use cases scenario, however I was able to natively achieve a similar outcome by following the steps below:
1. I have loaded demo data using Data load editor:
2. After that I have created the tables:
As you can see, selecting one value from the table 1 will not affect other values on the other tables. However, you want them to be affected and to apply the same selection range on them.
3. I have created a Filter pane and added the "Year" field as dimension.
Having this object, I will be able to select the desired values of the field "Year" and then apply the same selections on the other needed fields.
4. Therefore, I have created a button and added 3 actions with action set to "Select values in a field":
5. Now you can add the expression =Replace(GetFieldSelections(Year), ', ', '; ') on all actions under "Value" and for "Field" you have to select Year_Prime, Year_Surv and Year_Effect respectively.
6. After that, just select the values from the Filter pane that you want to apply and click on the button. The actions will transfer all your selections to the other fields automatically.
UPDATE:
You can also take a look in the Qlik Developer [1] page, where you can find extensions to achieve specific use case scenarios. For example, there is an extension E-mergo Triggers [2], which, according to the description, allows you to trigger actions based on changes in field selections. So you can add this extension to your app and then add the same actions described above, when the Year's field selections changes. This will allow you to avoid having the user to click on the button to apply the selections.
NOTE: Please keep in mind that there might be other extension available as well, however if you have any issues with how to use them or if there are any unexpected behavior, you will have to reach to the individual developers as those extension are not created by Qlik.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
[1] https://developer.qlik.com/
[2] https://developer.qlik.com/garden/5f5baa89773702001909d838
