Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want add in qlik sense a new object
In particular i want add this element: http://www.jbpivot.org/
Someone can i help me?
Thank you
Hi Marco,
Yes, I will spend time on integrating jbpivot into QlikSense. I realised that native complex expressions (Aggr(), FirstSortedValue() etc.) are not allowed in jbpivot. You can perform simple aggregations - Sum, Average and Count. Does this meet your requirements. Do you still want this visualisation object?
Thanks,
DV
Hi DV,
Yes, these functions are sufficient
I believe that this object is useful for subaggregation which is not the classic totals sum in native pivot table.
Thanks
Marco B.
Hi DV,
Just to give you a bit of a heads-up, implementing a Pivot Table extension using a library like jbPivot brings the following two challenges:
1) The heavy lifting of calculating the sub-totals is done by the JavaScript object itself which is not as performant as the Qlik engine and might significantly impact the RAM usage of the browser for large data sets.
2) You are strictly limited to counts and sums as the JavaScript object calculates the sub-totals using the aggregated table Qlik returns, which is not on a row level. This means non-summation aggregations, e.g. ratios, %, sum types of averages, weighted averages, medians and other complex expressions as you mentioned will not work using this approach.
The best way to develop an extension object which resembles Qlik's Pivot functionality and where all data including sub-totals is returned by the Qlik engine is to use a HyperCubeDef with qMode = P (DATA_MODE_PIVOT). However, I have not yet found a Pivot Table library which can handle this type of data and render it correctly, meaning it will probably need to be developed from scratch Or Qlik makes their basic chart objects open source and we can rip the code there
Let's catch up soon!
Martin
Hi Martin,
Agreed, that's exactly what I meant in my previous message to Marco. I wanted to know if Marco still wants this extension whilst considering the limitations on flexibility and performance.
Cheers,
DV
HI Martin,
now i have tried that you said and i have seen this your thread Retrieving SubTotals from a qHyperCube in DATA_MODE_PIVOT . Are you able to do this table?
Hi DV,
now i am trying follow the Martin indication.
i hope it
Thanks
Marco
Hi, Marco - I've managed to integrate jbPivot in Sense. There is still 50% of work (automating configuration etc.).
Good news - It works with Qlik Expressions (including Set Analysis).
Bad news - Surprise! Surprise!! Performance is not great with large data sets as there's a lot of calculation overhead in JS. I haven't tested enough but whatever I tested so far tells me that large datasets and higher dimensionality the data; you will more likely have issues with jbPivot.
Either way, I'll finish the extension in few days and update you.
All the best!
Cheers,
DV
www.QlikShare.com
Hi DV,
I'm curious how it works.
I believe we can use its with little data.
I wait your news.
Bye bye
Marco