Skip to content
This repository has been archived by the owner on Sep 28, 2021. It is now read-only.

Can not open app Sales_Anaylsis.qvf #122

Closed
FredrikFolkesson opened this issue Feb 4, 2019 · 0 comments · Fixed by #123
Closed

Can not open app Sales_Anaylsis.qvf #122

FredrikFolkesson opened this issue Feb 4, 2019 · 0 comments · Fixed by #123
Assignees
Labels
bug Something isn't working

Comments

@FredrikFolkesson
Copy link
Contributor

FredrikFolkesson commented Feb 4, 2019

The problem can be seen with the get meta command

@FredrikFolkesson FredrikFolkesson added the bug Something isn't working label Feb 4, 2019
@FredrikFolkesson FredrikFolkesson self-assigned this Feb 4, 2019
@FredrikFolkesson FredrikFolkesson changed the title Can not open app Sales_Anaylsis.qvf Can not open app Sales_Anaylsis.qvf Feb 4, 2019
FredrikFolkesson added a commit that referenced this issue Feb 11, 2019
This fixes #122

Now you get the same tables that you get in Qlik Sense

There seems to be a mismatch between the tables that are included by using `GetTableAndKeys` and when using this hypercube

```
	object, _ := doc.CreateSessionObject(ctx, &enigma.GenericObjectProperties{
		Info: &enigma.NxInfo{
			Type: "my-pivot-hypercube",
		},
		HyperCubeDef: &enigma.HyperCubeDef{
			Dimensions: []*enigma.NxDimension{
				{
					Def: &enigma.NxInlineDimensionDef{
						FieldDefs:     []string{"=$Field"},
						SortCriterias: []*enigma.SortCriteria{{SortByExpression: -1, Expression: &enigma.ValueExpr{V: "=count($Table)"}}},
					},
				},
				{
					Def: &enigma.NxInlineDimensionDef{
						FieldDefs:     []string{"=$Table"},
						SortCriterias: []*enigma.SortCriteria{{SortByExpression: -1, Expression: &enigma.ValueExpr{V: "=count($Field)"}}},
					},
				},
			},
			Measures: []*enigma.NxMeasure{
				createMeasureSortNumeric("=sum($Rows)", &enigma.SortCriteria{SortByNumeric: -1}),
			},

			InitialDataFetch: []*enigma.NxPage{{
				Height: 1000,
				Width:  1000,
			}},
			Mode:         "P",
			NoOfLeftDims: &noOfLeftDims,
		},
	})
```

I think the later one returns a few system tables? that I think should not be included (if we want to include them we will have to handle this in another way so corectl does not crash when there is a system table that has no table record)

In the `Sales_Anaylsis.qvf` app it was the tables: `_tabToday`,`Dimensions`,`Measures` that was the problem.
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant