Hello,

I need to show the result of diferent Data Qualities in diferent Excel files (one per DQ).

So I have a table with all the Data Quality types and their headers (fields):

And a table containing all the data with all the possible fields in any DQ:

So, I was able to make a cycle in NPrinting to print a file per DQ, using the DQ Name as dimension for the cycle:

The problem now is that I don't know how to make NPrinting include just the fields of each DQ in its file. I mean, in the Excel template I have a table with all the posible fields in all DQs (based on DQ_CUSTOMER table), and what I need is that NPrinting uses only the corresponding fields of each DQ, based on the "DQ_VIEW_FIELDS" field that contains all the fields of each DQ.

In draft, something like this:

Table with headers (fields) per DQ:

Table with all fields of all DQs:

File for DQ 1

File For DQ 2

File For DQ 3

Any idea will be really appreciated.

Thank you.

Hi Everyone

I am trying to connect Load and SQL Statement after I drop the table (so not using concatenate as I am not using star scheme in this case). I want to connect additional dimension to existing model through ID. Can you advise please?

Many thanks

Is there any way to extract data from QVD file using .NET?

I need to get at least XML header to describe the fields in the table, the layout of the subsequent information and other meta-data

Thanks in advance.

According to Qlik help an user with analyzer license can add private sheets. The text says "You can explore and make data discoveries in apps. In some apps, you can add your own private sheets and stories, but you cannot share these with other users."

I am trying to figure out how to give the Analyzer user this possibility, but I can not find out how to do it. Does anybody know?

HI All

Right now i am working with Qlik Section access but i am able to apply section access.

but i want to see total number of supervisor 

For Example i am A person.i am open my A access based app, I can be see only A Data that is 10 but i want to see C is 30 and D is 100 as well in my app  

How can i see both C and D total data

Hey 

I have this data

We have patients and status for a program in MonthYears

I am trying to discard values in Script, for example, for patient 876978, if i have more than one record in a MonthYear, i should keep only Active status, but if i only have one record per MonthYear i should keep the same status.

This is the result that i should have:

Any ideas?

Thanks in advance.