hey all,

is there a way to change the font size of axis labels and value labels in the charts (e.g. bar chart), without going down the customized theme route ? this is crucial for my use case since the dashboard users need to export the report to PDF. the default font size is way too small. 

any ideas are appreciated!! thanks.

Hi All,

I have attached excel file which contains data and requirement. I want to create a report with status and there is logic to create status in attached file. I have also attached screenshot 

I have a table with columns employee id and their best attendence and current attendence, I want to display in a simple table, first column should be employee id and second column should be his best attendence and third will be current attendence,

In this best attendence will be increasing day by day until he takes leave,and if he takes leave then current attendence will come to 0 and start again.

Here I need to display distinct employee id and their best attendence and current one, and in this best attemdence should remain same and should not change for any filters, it should always display the maximum of the employee, where as current attendence should display the maximum on that particular date.

Input table:

Employee id.    Best     current

123.                     48.          48

123.                      48.           0

123.                      48.            1

Output expectation:

Employee id.      Best.   Current

123.                     48.         1

How can we achieve this

Hello,

I have of QVDs being generated by QVWs, these QVWs are set to reload every 10-15 minutes. At times, the QVDs get locked and no further data gets loaded.

When I run the QVW manually myself via the QlikView application, I receive an error stating that the QVW project wasn't able to access / write to the QVDs in order to insert additional data into them, but QMC does not report any of these errors at all? It is almost like the QVW keeps moving past the errors and just not storing the data into the QVDs for some reason.

Because of this, we do not get any data stored into the QVDs, but the QVW file 'Date Modified' changes and there are no errors in the QMC against the QVW reload... Attached is the error in QlikView, but QMC reports nothing and shows successful reloads...

Thanks!

We use the List files block to access files on our SharepointOnline site

How can we achieve recursion to navigate into subfolders without knowing the depth of folder hierarchy?

At the end, we want a list of all leafs (files), no matter how many subfolders exist and how deep hierarchy goes.

We want to avoid using a nested blocks scenario like this

Any ideas would be highly appreciated 👍 

Bonjour,

Je souhaite générer un fichier XML avec deux boucles, mais le composant: "tAdvancedFileOutputXML", n'en supporte qu'une seule… J'ai essayé d'utiliser l'option: Paramètres simples/ Écrire les données à la fin du fichier source, mais j'ai un message d'erreur, que je n'ai pas pu résoudre.

Par avance merci pour vos solutions.

Vassil

Hello,

I have a table whose rows I am looking to color according to the textual value in ColumnC (see exemple below). If I have 3 possible values ​​in ColumnC then I would have 3 colors. I cannot know before which values ​​that will be in the ColumnC (it depends on the data) therefore this color assignment must be somehow dynamic. How to do it?

Thanks.

Hello there!

I have the need to export many different datasets from the very same table in Qlik Cloud Analytics. Each export has a different filter applied (or many different filters, but one is the main one that I need).

Qlik Sense Analytics allows exporting data from the selected chart to Excel (when available) and takes the name of the chart to be included in the filename.

To make this process simpler, I added the correct dimension I am filtering with so the filename has it. However, there is an issue here. The exported filename has added "Qlik Sense" as prefix and today's date in mmm-dd,yyy format as suffix, just as an example:
Qlik Sense - Chart Name - November 8, 2024.xlsx

This reduces the information to be included in the filename since the export has a limited number of characters (not 255 as Windows normally allows).

To explain further what I need, I will use a sample data table, which has all the records:

To have the filter in the filename, I added this to the chart title:

Then, I need to export data with filter on [Group Colour] = 1, I get this:

And when using [Group Colour] = 2, I get this:

But the filenames are like this:

For just a few files, I wouldn't mind editing the filenames to delete the default prefix and suffix, but for many files and quite frequent data exporting, this becomes a tedious and unnecessary task.

And when the chart name has more information (a longer name or more than  one filter added), the filename is cut by Qlik Sense but the prefix and suffix remain... so, not very useful.

I searched in the Qlik Help in the data export sections, but there is no info on how to modify these prefix and suffix in the data export filename.

Is there a way to do that? Any help will be appreciated.

Thank you! 

I have Qlik Replicate version  May 2023 (2023.5.0.771). 

I see the early builds version 2023.11 and 2024. Which one should I apply? 

Please advise.