B4J Tutorial [BANanoWebix] WixPivot on PRO (OffTopic)

Discussion in 'B4J Tutorials' started by Mashiane, Jul 10, 2019.

  1. Mashiane

    Mashiane Expert Licensed User

    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...

    WixPivot.gif

    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...

    Code:
    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!
     
  2. Mashiane

    Mashiane Expert Licensed User

    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)

    pivot.png
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice