B4J Tutorial [BANanoWebix] WixPivot on PRO (OffTopic)

Ola

This is not a tutorial but just an off topic issue pertaining to BANanoWebix and the PRO widgets.

Webix besides the open source Webix offering, which BANanoWebix is based on, provides a variety of professional widgets that one can use for their apps.

These include amongst other things the following:

• KanBan
• Pivot
• PivotChart
• QueryBuilder
• ExcelReporter

and many more others

So as it, I got a request to look onto the Webix PivotChart, one of the PRO widgets from webix. After spending an hour or so last night learning about it from the 30 trial download they give you, we managed to pull it off and implemented everything in their examples to make this tick...

So in case you also find something that you'd like to use from their professional offering that WILL NOT be part of BANanoWebix, give me a shout and I can do it for you. These will be done on request as I will not delve into the PRO widgets anytime soon.

I'm hoping the person requesting this will be excited about it as much as I am.

A preview of the code that makes this work...

Sub Init(pgContainer As String)
    'initialize the page
    Page.Initialize("wp",pgContainer).SetResponsive("master").SetHeader("Professional: WixPivot")
    'create a row
    Dim r1 As WixRow = Page.Page.CreateRow("R1")
    'get the pivot dataset
    Dim pd As List = BANano.RunJavascriptMethod("getPivotDataSet", Null)
    'create pivot
    Dim pvt As WixPivot
    pvt.Initialize("pvt")
    pvt.SetData(pd)
    pvt.SetMax(True)
    pvt.SetRows(Array("form", "name"))
    pvt.Setheight(400)
    pvt.SetWidth(1000)
    pvt.SetSeparateLabel(True)
    pvt.SetColumns(Array("year"))
    pvt.SetValuesSum(Array("gdp", "oil"))
    pvt.SetFilterSelect("name")
..
..
..
..

Ta!

 

[Mashiane]

An eye opening interesting journey and what we ended up doing...

1. Complete translation to Spanish
2. Drill-down on double click
3. Color coded headers
4. Monetary value formatting
5. Close all headers
6. Printing (tests)
7. Exporting (excel, pdf, csv) (tests)