Good morning 😊,

I created a mashup with the Dev Hub.
I want to export it to PDF, to a button I created.

All objects are native Qlik graphics.
Only, one does not appear on the pdf: Radar Chart (Qlik Visualization bundle).

Here is my export code:

(document). on('click','#capture',function convert_HTML(){
let pdf = new jsPDF('l', 'mm', [250, 297]);

let section=$('#test');

let page= function() {
pdf.save('Mission_Value_Assessment.pdf');

};

pdf.addHTML(section,0,0, page);

Capture is the button id in html
test is the id of the body.

Qlik Visualization Bundle can be exported in jpg or png format but not in PDF.

Do you know what I can do please?
Thank You!

How to concatenate multiple comma-separated lists, as in the following example.

-> INPUT

ID        |       ColA     |     ColB      |     ColC       |

--------------------------------------------------------------

1          | 1A              | 1B              | 1C              |

2,3,4    | 2A, 3A, 4A | 2B, 3B, 4B | 2C, 3C, 4C |

5,6       | 5A, 6A       | 5B, 6B        | 5C, 6C       |

<- OUTPUT

1          | 1A              | 1B              | 1C              |

2          | 2A              | 2B              | 2C              | 

3          | 3A              | 3B              | 3C              | 

4          | 4A              | 4B              | 4C              | 

5          | 5A              | 5B              | 5C              | 

6          | 6A              | 6B              | 6C              | 

Any ideas or suggestions?
Thanks.

Dear All,

I need  to connect Lucanet cubes with Qliksense.  Is there any dedicated connector to do that  ?   Or I have to connect directly to the database  ?

Thank ou for your help 

Hello Qlik Community,

We're thrilled to introduce our featured member for the month of June: Théo Atragie! Théo joined our Community in October 2023, and since then, he's been shining bright as one of our rising stars. As a data consultant at ACSSI, a leading French digital service company, Théo has quickly established himself as a key player in the Qlik ecosystem. With a keen focus on Qlik Sense, he dedicates his time to mastering the intricacies of data analytics and visualization.

What sets Théo apart is not just his expertise but also his unwavering commitment to helping others. Despite being a relatively new member, Théo is constantly engaged and active in our Community. He consistently stays on top of the leaderboards and is always ready to lend a helping hand to fellow Community members.

In his own words, Qlik isn't just a tool for me; it's a gateway to observation and discovery. Spending time in the Community is something I enjoy because it allows me to both receive and give knowledge, enriching my pedagogy.

In his life outside of data analytics, Théo enjoy participating in sports, particularly running. He recently completed the Paris Marathon, showcasing his determination and endurance. Based in Baisieux, France, Théo embodies the spirit of our global Community, bridging geographical boundaries to connect with fellow Qlik enthusiasts worldwide.

Please join us in congratulating Théo for his outstanding contributions to the Qlik Community. Let's show our appreciation by commenting and hitting that like button! Thank you, Théo, for inspiring us with your dedication and passion. @Sue_Macaluso @Melissa_Potvin @nicole_ulloa @Jamie_Gregory @theoat 

Hello we have a speed(mb/s) limitation on the brokers after Qlik of mb/s

therefore we asked ourselves the question if he was possible on the db2 z endpoint source to limit the number of records obtained per second or the retrieval size

Bonjour, 

J'ai débuté Qlik Sense il y a quelques jours, et après avoir cherché pas mal de temps, je n'ai pas trouvé la réponse à ma question : 

J'ai une table qui contient des champs, et je voudrais que lorsque je clique sur un champ, toute la ligne devient sélectionnée. Sauf que, quand je clique sur cette ligne, il faut que la table reste inchangée, que ça n'affecte pas les autres lignes de celle-ci, mais il ne faut pas que ce soit en "Read-Only" car la ligne sélectionnée d'interagir avec une autre table. 

Merci d'avance pour vos réponses, je reste disponible si vous avez des questions. 😄

Hello, I can't understand how set analysis works in this case, because despite having inserted into the measure what I am looking for and having told the measure to use the set analysis over each function that needs it, the results do not match.

See screenshots below, when I don't select any employee, the measure 'Team Measure' works fine: 

However, when I select an employee, the measure suddenly turns to the same output as the employee selected: 

This is the measure I am currently using: 

// All Other Employees Measure
Sum(
    Aggr(
        {< Employee= >}  // Ignore selection of Employee
        Count({< ACTION_CODE = {'LABOR_OFF'} >} distinct MainSFC) * Avg_Time,
        MainSFC, Employee
    )
)
/
(
Sum(
    Aggr(
        {< Employee= >}  // Ignore selection of Employee
        Count(distinct WorkingDay) * 7.5 * 60,
        Employee
    )
)
    -
	Sum(Absence) * 60

)

Can someone please help me figure out what I am doing wrong? 

Hi Team,

I need to pull data in QlikView how many  reports/dashboards are using Oracle data base for entire QlikView environment. 

For example if there are 100 reports available in QlikView environment. Let us say there are 50 reports are using oracle data base. I want to know that 50 count.

Is there any way we can pull data or any short cuts find it? Kindly help me. 

Regards,

Siva

I have a job that connects to extract the data from several objects from salesforce.

I use tsalesforceinput to extract the data and then insert into a mssql db. the job return this error with some objects but others work without problem. 

tSalesforceInput_2 SSL peer shut down incorrectly
javax.net.ssl.SSLException: SSL peer shut down incorrectly
at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:596) ~[?:1.8.0_252]
at sun.security.ssl.InputRecord.read(InputRecord.java:532) ~[?:1.8.0_252]
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:990) ~[?:1.8.0_252]
at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:948) ~[?:1.8.0_252]
at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[?:1.8.0_252]
at java.io.BufferedInputStream.fill(BufferedInputStream.java:246) ~[?:1.8.0_252]
at java.io.BufferedInputStream.read1(BufferedInputStream.java:286) ~[?:1.8.0_252]
at java.io.BufferedInputStream.read(BufferedInputStream.java:345) ~[?:1.8.0_252]
at sun.net.www.http.ChunkedInputStream.fastRead(ChunkedInputStream.java:244) ~[?:1.8.0_252]
at sun.net.www.http.ChunkedInputStream.read(ChunkedInputStream.java:689) ~[?:1.8.0_252]
at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[?:1.8.0_252]
at sun.net.www.protocol.http.HttpURLConnection$HttpInputStream.read(HttpURLConnection.java:3454) ~[?:1.8.0_252]
at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:238) ~[?:1.8.0_252]
at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[?:1.8.0_252]
at java.util.zip.GZIPInputStream.read(GZIPInputStream.java:117) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:284) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:326) ~[?:1.8.0_252]
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:178) ~[?:1.8.0_252]
at java.io.InputStreamReader.read(InputStreamReader.java:184) ~[?:1.8.0_252]
at java.io.BufferedReader.fill(BufferedReader.java:161) ~[?:1.8.0_252]
at java.io.BufferedReader.read1(BufferedReader.java:212) ~[?:1.8.0_252]
at java.io.BufferedReader.read(BufferedReader.java:286) ~[?:1.8.0_252]
at com.csvreader.CsvReader.checkDataLength(Unknown Source) ~[javacsv-2.0.jar:?]
at com.csvreader.CsvReader.readRecord(Unknown Source) ~[javacsv-2.0.jar:?]
at org.talend.components.salesforce.runtime.BulkResultSet.next(BulkResultSet.java:21) ~[components-salesforce-runtime-0.36.13.jar:?]
at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.advance(SalesforceBulkQueryInputReader.java:72) ~[components-salesforce-runtime-0.36.13.jar:?]
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.advance(FlowVariablesReader.java:78) ~[talend-codegen-utils.jar:?]

Any suggestion?

I have the following section access script in my hidden script - 

Section Access;

LOAD * INLINE [
ACCESS,  NTNAME,              OMIT,       SLRLEVEL8,    SLRLEVEL7
ADMIN,     DOMAIN\USER1,   *,             *,                       *
ADMIN,     DOMAIN\USER2,   *,             *,                       EMERGENCY DENTAL SERVICE
ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       EMERGENCY DENTAL SERVICE
ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       SPECIAL CARE DENTAL SERVICE
];

Section Application;

When opening the dashboard my log in - DOMAIN\USER1, I can only see EMERGENCY DENTAL SERVICE and SPECIAL CARE DENTAL SERVICE and cannot see NHSNO.

Why is this happening? I should be able to see everything

Thanks

Kev