Vizlib Community

Submit a ticket My Tickets
Welcome
Login

Pivot Table - unchecked 'Show Zero Values' - first row deleted as well

I think I found a bug in the pivot table.


I am showing some information with country rows and month columns. The countries are dual type to show them in a certain order.

With 'Show Zero Values' checked in Data Handling it shows all countries, but there are zero values for the countries in the top:

image


If i now uncheck this option it gets rid of all the countries without information, but also cuts of 'DE' which does not have a zero value:

image



  • I just created a test app. It seems like this is a bug. Unfortunately I can not create a qvf and upload it, but I can supply you with an xlsx to load.


    In the Dataeditor load the file like this:

     

    Map:
    MAPPING LOAD * INLINE 
    [
    country, order
    DE, 0
    GB, 1
    IT, 2
    US, 3
    ];
    
    
    LOAD
        Dual(Country, ApplyMap('Map', Country)) as Country,
        Value,
        "Month"
    FROM [lib://path/to/file\Test.xlsx]
    (ooxml, embedded labels, table is Tabelle1);
    
    

     Then create a VizLib Pivot Table with Country as rows and Month as column. For the Value use the following code:

     

    Dual(sum(Value), max(Country))

     You can observe the same behaviour as in my screenshots.

    xlsx
    (9.73 KB)
  • I just created a test app and it seems like this is a bug. Unfortunately I can not upload a qvf, but I can supply you with the xlsx to load.


    In the dataeditor load the file with the following code:

     

    Map:
    MAPPING LOAD * INLINE 
    [
    country, order
    DE, 0
    GB, 1
    IT, 2
    US, 3
    ];
    
    
    LOAD
        Dual(Country, ApplyMap('Map', Country)) as Country,
        Value,
        "Month"
    FROM [lib://path/to/file\Test.xlsx]
    (ooxml, embedded labels, table is Tabelle1);
    
    

     Then create a VizLib Pivot Table with the country as rows and Month as the column. For the calculated value use this code:

     

    Dual(sum(Value), max(Country))

     You can observe the same behaviour as in my screenshots

    xlsx
    (9.73 KB)
Login to post a comment