topic Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode) in Integration, Extension & APIs

Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

Thomas91 — Sat, 16 Nov 2024 04:07:00 GMT

Hey everyone,

I'm looking for help/advice/expertise if possible.

I'm currently developing a mashup and I'm trying to present a bar chart in a stacked format however I can not for some reason get the object to render correctly.

Code I'm using is below;

app1.visualization.create(
'barchart',
[
{
"qDef": {
"qFieldDefs": [
"=Dual(MonthYear, MonthStart(CalendarDate))"
],
"qFieldLabels": ["Year"],
"qSortCriterias": [
{
"qSortByNumeric": 1
}
],
"autoSort": false
}
},
{
"qDef": {
"qFieldDefs": [
"Incident: Priority"
],
"qFieldLabels": [
"Priority"
]
}
},
{
"qDef":{
"qDef": "=$(vServiceDeskCallsRolling13)",
"qLabel": "Number of Calls (by Start Month)"
}
}
],
{
"showTitles": true,
"title": "Call per Month",
"showDetails": false,
"qHyperCubeDef": {
"qMode": "K"
},
"barGrouping": {
"grouping": "stacked"
}
}
).then(function(vis){
vis.show("QV11",{"noInteraction": true});
});

Does anybody have any ideas?

Thank you.

Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

oz_moyal — Thu, 14 Nov 2019 14:00:38 GMT

Is this issue specific to this object ?
are u able to produce other objects ?

does QV11 has fixed height/width ?

Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

Thomas91 — Thu, 14 Nov 2019 14:04:40 GMT

Hi!

I am able to produce other objects. I am able to produce a bar chart and a grouped bar chart but I am not able to change the grouping to "stacked". All this is with object "QV11".

QV11's height is set to 350px within the html styling.

I am using grid within the CSS styling.

Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

Deny12 — Tue, 09 Jun 2020 23:12:36 GMT

Hi,

Were you able to get the stacked bar properly?

I am also trying to develop stacked bar graphs and

{
"qHyperCubeDef": {
"qMode": "K"
},
"barGrouping": {
"grouping": "stacked"
}
}

does not seem to be working but grouped and basic bar graphs work fine.

Could anyone help me out please if you have got this?

Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

sullivlo — Wed, 29 Jul 2020 20:10:28 GMT

"qHyperCubeDef": {

"qMode": "K",

"qAlwaysFullyExpanded": true

"barGrouping": {

"grouping": "stacked"

}

Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

briwilli — Fri, 16 Oct 2020 22:27:18 GMT

Thanks Sullivlo, I was facing the same problem and your response resolved my issue after spending a number of hour trying different settings. The official documentation that I reviewed never mentioned requiring the qAlwaysFullyExpanded property. Curious, how did you discover this solution? Thanks again.

Re: Qlik Sense Mashup - Stacked Bar Chart (qHyperCubeDef - qMode)

sullivlo — Mon, 19 Oct 2020 12:47:53 GMT

I looked at the json output of a working stacked bar chart that I built in the app then pulled into the mashup using the chrome extension add sense.