How to combine as one table

I have three tables

table1:

table2:

table3:

I want output like below

I am using a REST API to retrieve info from a report provided by NPrinting. Through this request I am also passing some filter info to extract info from only one customer.

This works great if the Nprinting report aquires its info only one source / connectionId.

However, the NPrinting report contains info from different sources provided by different connectorId's  .

Retrieving both these charts from this report by REST , will apply my filter to the first connector, but will NOT apply this to the second chart info ; all customer info will be extracted unfiltered. 

{

    "type": "report",

    "config": {

        "reportId": "123-465",

        "outputFormat": "pdf"

    },

    "filters": {

        "initialBookmark": "",

        "additionalFilters ": []

    },

    "connectionId": "654-321",

    "selections": [

        {

            "fieldName": "RELATIE_ID",

            "selectedCount": 1,

            "selectedValues": [

                "1234"

            ],

            "isNumeric": false

        }

    ]

}

Can I retrieve info from a current Nprinting report that has more than one different connectionId 's ? Adding twice "connectionId": "654-321" is a failure,

The field to be filtered (RELATIE_ID) is the same for both charts.

The only info that I can find is Qlik NPrinting API − OnDemandRequest - Qlik | Help and here the connection is only a string and not an array .

Hi All, 
I have a pivot table in QlikSense with 2 dimension(Country and City) and one measure with expression (A/B).
I have converted Pivot table to straight table and using Excel Pivot option for designing the structure w.r.tPivot table in QS, I Need to show Grand total in Pivot table in NPrinting , but its not matching with QS total which we enabled total feature from presentation tab. As per my analysis ,NP total simply doing the summation of final output (A/B) of measure values across each dimention values instead of calculating sum (A) and SUm (B) at overall level and doing the division . 

To handle this , i have created variable with expression in QS for showing grand total by not using excels grand total , but since data is dynamic, i am unable to find the position for placing this and also we are dealing with 2 dimensions in pivot.

Please help

@Lech_Miszkiewicz  @Ruggero_Piccoli 

Hi, 

I am wondering how I can take a plain date field and set it up in a table or filter so that the dates are filtered into Pay Periods (2-week groupings)? Appreciate any help!

Hello,

I am an amateur, and I am approaching qlikview, I  am having a problem with the totals.

The data is calculated with a simple sum().

As you can see in the image there is a sum problem, the strange thing is that the total is right, while the lines are wrong, because there are products that are added both in the first line and in the second row. 

what I ask, if it is possible to repartition the total in the rows in percentage and never exceeding the "CARICATO" column.

I apologize in advance for my basic level English. 

Hi everyone who's reading this!

I have simple question but cannot find anything online about this.

We have two QlikView environments, one test environment and one production environment.

In the test environment we are able to change Max number of simultaneous QlikView engines for distribution. 

In the live environment we are unable to change the Max number of simultaneous QlikView engines for distrubiton.

On the test and production environment we have different licenses, the test environment has NUMBER_OF_CLUSER_NODES.;2;; and the production environment has NUMBER_OF_CLUSER_NODES;1;;. 

The test environment.

The production environment.

If this is an license issue is there a workaround to upscale the Max Simultaneous Engines?

Thanks in advance! 

Hi,

I have struggle with this calculated field I need to make.

In first case i need to mark all rows that contains "TBC" in field Customer PO as "DUMMY-COMMITED"

In secon case i need to mar all rows that contains "DUMMY" as "DUMMY"

Rest should be marked as "COMMITED"

Is there any expression that should solve this?

l(If(WildMatch([Customer PO],'TBC'),'DUMMY-COMMITED',(IF(WildMatch([Customer Code],'DUMMY'),'DUMMY','COMMITED'))))