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

Data Table Issue #61

@significantis

Description

@significantis

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions