Unable to get data from Qlik Table

[Anku]

Hi all,

I am trying to fetch a table from qlik sense app in Qlik designer but everytime I hit preview, there is no data.

The potential reason I can think of it one of my column is created

using "Measure":

dummy example: count({<Date = {"dd-mm-yyyy"}, Col1 = {'A'}>}id).

and remaining dimensions which are being shown as per above measure.

Can anyone tell me how to solve it. Thanks! 

[Ruggero_Piccoli]

Hi,

First of all February 2019 is no more supported, so I suggest you to plan the upgrade of your installation as soon as possible. 

Give a check ant the following conversation: https://community.qlik.com/t5/Qlik-NPrinting/Gauge-from-Qlik-sense-into-Nprinting/m-p/1861566 

Best Regards,

Ruggero

[Lech_Miszkiewicz]

Agree with @Ruggero_Piccoli and also:

1. are you running supported configuration?  Yes or No?
   1. if you are on NPrinting Feb 2019 then you also MUST be only on supported then version of Qlik Sense (which would be Feb 2019 or older) 
2. is your Qlik Sense app supported? Yes or No?

   1. You should not create connections to Qlik Sense apps that use the following:

      • Always one selected value for fields

      • Calculated dimensions

      • Drill-down dimensions

      • Alternate states

      • Sheet triggers

      • https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/GettingStarted/HowCreateConnect...

3. Have you got section Access? Yes or No?
4. Have you got any variable inputs which could modify your expression? Yes or No?
5. Have you got any NPrinting filters created and associated with either you (user filters) or the report?Yes or No?

Depending on above answers we can try to help you but ensuring that you are on currently supported configuration is critical - if you are not that is the first thing you need to fix before checking anythign else. 

cheers

[Anku]

My apologies, NPrinting version is may 2023.
Yes, I have calculated dimension.

[Anku]

Yes, it is may 2023 and I requested admin team to make these changes but they are seeking further approval.

[Lech_Miszkiewicz]

Hi @Anku 

put yourself in our shoes and try answer your question. We need to be able to replicate your environment without seeing it. With NPrinting everything matters. Even if you think that something doesnt matter you need cosnider it as potential cause of the problem. 

You must check that your environmnet is fullty supported (please provide exact version also of your Qlik Sense). Check the compatibility chart for your version of NPrinting: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/System-requirem...

Now we dont know anything about your "table object" you are trying to use. Is it the Qlik Sense native straight table chart or is it some sort of third party extension (like vizlib or similar)? Note that third party object may or may not work and you would have to work with that object developer to ensure all requirements for that extension are met.

Meanwhile I suggest we take different approach: 

• go to Qlik Sense and create new app using CTRL+0+0 script
• generate data from that script and create straight table chart with Dim1 as dimension and sum(Expression1) as measure
• create new NPrinting app
• create a connection to that new Qlik Sense app within your new NPrinting app and reload metadata
• create new report and use that one table as a table object in it
• run preview and see if you have results

All above you screenshot step by step so we can see if there are any issues in the way you do it

If your preview works then issue is in the way how your original Qlik Sense app is built and then you will know that you are using something in that app what is causing issues. That could be something in your data model, in the way you interact with objects etc... note that NPrinting clears all selections so make sure your table has records in it when all selections are cleared or you will need to apply NPrinting filters to put required selections back.

cheers