topic Re: app.CreateCube - Get all the values instead of current selections in Integration, Extension & APIs

app.CreateCube - Get all the values instead of current selections

s29124141 — Mon, 23 Oct 2017 21:09:38 GMT

I am using createCube method and I get only the current selections if there is any selections and all the values if there is no selection. Can some one help me fetch all the values even irrespective of current selections. Tried passing different "qStateName" to the createcube hypercube definition, nothing works.

Below are the help links followed.

createCube method ‒ Qlik Sense

HyperCubeDef ‒ Qlik Sense

Tagging experts for help. erik.wetterberg‌ jvs‌

Re: app.CreateCube - Get all the values instead of current selections

Vincenzo_Esposito — Tue, 24 Oct 2017 06:13:54 GMT

Did you pass also the value 1 in the qState which actually means for Qlik (do not consider current selection)?

Re: app.CreateCube - Get all the values instead of current selections

ErikWetterberg — Tue, 24 Oct 2017 11:53:25 GMT

Hi,

Try creating the alternate state before using it.

Hope this helps

Erik Wetterberg

Re: app.CreateCube - Get all the values instead of current selections

Yianni_Ververis — Tue, 24 Oct 2017 12:49:15 GMT

Did you try to add {1} before your field in your Set Analysis?

Re: app.CreateCube - Get all the values instead of current selections

s29124141 — Tue, 24 Oct 2017 17:26:52 GMT

I tried passing qStateName as '1', still it returns me only the currently selected values.

HyperCubeDef: {
            qStateName: '1',
            qInitialDataFetch: [{ qHeight: 500, qWidth: 3 }],
            qDimensions: []
        }

Re: app.CreateCube - Get all the values instead of current selections

s29124141 — Thu, 26 Oct 2017 04:41:02 GMT

I ended up creating new island table fields, which not be used for user selection and create the cube out of it. Thanks all for the help!

Its so weird that app.CreateCube does not have feature to get all the selections.

Re: app.CreateCube - Get all the values instead of current selections

dannyy81 — Thu, 07 Nov 2019 17:46:48 GMT

I wonder if there is solution other than island table

Re: app.CreateCube - Get all the values instead of current selections

muhammadraza — Tue, 07 Jun 2022 09:10:55 GMT

I resolved it by ignoring the fields selection in the set analysis in qMeasures

"qMeasures":[
{
"qDef":{
"qDef":"num(Count({<group=, field1=, field2=, field3=, parent=>}person))"
},
"qLabel":"test",
"qLibraryId":null,
"qSortBy":{
"qSortByState":0,
"qSortByFrequency":0,
"qSortByNumeric":0,
"qSortByAscii":1,
"qSortByLoadOrder":0,
"qSortByExpression":0,
"qExpression":{
"qv":" "
}
}
}
]