topic Re: Use calculated dimension in hypercubedef in Integration, Extension & APIs

Use calculated dimension in hypercubedef

Anonymous — Sat, 16 Nov 2024 07:01:25 GMT

May I know how to send a calculated dimension in qlik config?

Usually, when sending the config to engine, we put the field name under qFieldDefs. In below code, it's SOMEFIELD.

{
	"handle": 1,
	"method": "CreateSessionObject",
	"params": {
		"qProp": {
			"qInfo": {
				"qId": "",
				"qType": "HyperCube"
			},
			"qHyperCubeDef": {
				"qDimensions": [
					{
						"qNullSuppression": false,
						"qDef": {
							"qFieldDefs": [
								"SOMEFIELD"
							]
						}
					}
				],
				"qMeasures": [],
				"qInitialDataFetch": [
					{
						"qHeight": 10000,
						"qWidth": 1
					}
				]
			}
		}
	}
}

However, I want to pass a calculated dimension, like the following:

AGGR(DISTINCT Rank(FIELD1,4,1),FIELD2)

I really don't have any idea where to put a calculated dimension. Please advise.

Re: Use calculated dimension in hypercubedef

Øystein_Kolsrud — Tue, 18 Dec 2018 06:35:44 GMT

It should be sufficient to add a '=' character to the beginning of the string used for the qFieldDefs property. So instead of "SOMEFIELD" you could write

=AGGR(DISTINCT Rank(FIELD1,4,1),FIELD2)

Re: Use calculated dimension in hypercubedef

Anonymous — Tue, 18 Dec 2018 06:55:02 GMT

My question is actually where to put that calculated dimension inside the config.

Re: Use calculated dimension in hypercubedef

Øystein_Kolsrud — Tue, 18 Dec 2018 07:39:49 GMT

Oh... Just put it right in the "qFieldDefs" list just like you did for "SOMEFIELD".

Re: Use calculated dimension in hypercubedef

Anonymous — Tue, 18 Dec 2018 07:42:58 GMT

it doesn't work

Re: Use calculated dimension in hypercubedef

Øystein_Kolsrud — Tue, 18 Dec 2018 08:15:43 GMT

Hmm... It should. What kind of error are you getting? I added a calculated dimension to the following example that illustrates how to use hypercubes in the .Net SDK:

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/blob/master/HypercubeUsage/Program.cs#L113

That example produces a hypercube that is defined like this:

"qHyperCubeDef": {
  ...
  "qDimensions": [
    {
      ...
      "qDef": {
        "qFieldDefs": [
          "=Year(TimeStamp)&'-'&Month(TimeStamp)"
        ],
        ...
      }
    }
  ],
  "qMeasures": [
    {
      ...
      "qDef": {
        ...
        "qDef": "Sum([Sales Amount])"
      }
    }
  ]
}

Re: Use calculated dimension in hypercubedef

Anonymous — Tue, 18 Dec 2018 08:22:17 GMT

Sorry, you're right. It works. I think I might have forgotten to put the '=' sign or create the necessary variable. Thanks a lot.