Skip to content
This repository has been archived by the owner on May 24, 2024. It is now read-only.

Data Table Issue #61

Open
significantis opened this issue Dec 13, 2021 · 0 comments
Open

Data Table Issue #61

significantis opened this issue Dec 13, 2021 · 0 comments

Comments

@significantis
Copy link

Description

Hello, I am successfully using the SSE-R-PLUGIN in Qlik Sense. However, I reckon there might be a glitch when passing some Qlik data to R and back in a data table.

My goal is very simple. I have a Variable, say Var1, with values 1 to 10. I put this variable in the first column of my data table. Then I select the second row and simply pass Var1 to R and back (identity). I expect a second column, say VarR, to be a copy of Var1, but Qlik shows an error. Saving the data on the server via R then shows that some data was not completely passed from Qlik.

Steps to Reproduce

  1. Create dimension Var1 = 1, 2, 3, ..., 10.
  2. Pass Var1 into a data table as dimension.
    image
  3. Open a second column VarR and add the following code: =R.ScriptEvalEx('N', 'q$v1', Var1 as v1) -> Qlik shows an error.
  4. Change the code of VarR as follows: =R.ScriptEvalEx('N', '1:10', Var1 as v1) -> Works and shows a copy of Var1.
  5. Change the code of VarR as follows: =R.ScriptEvalEx('N', 'saveRDS(q$v1, "test_data.rds"); 1:10', Var1 as v1) -> Gives a weird output for VarR with all 1s. In addition, the stored data in the backend is NULL.
    image
    image
Expected behavior

Qlik sends all data to R and back. A second column VarR appears with the same values as Var1.

Actual behavior

An error in Qlik. No data transmitted to R.

Environment

Operating system where the SSE plugin is deployed
[ X] Windows
Qlik Sense
[ X] Desktop

Versions

  • sse-r-plugin: 1.1.0
  • Qlik Sense: 14.20.10
  • Operating system: Windows Server 2019
  • R: 4.0.2
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant