Bonjour à tous,

J'ai réalisé un TCD de ce genre dan Qlik Sense Business 

J'aimerais afficher la colonne "VS N-1"  uniquement pour l'année en cours soit uniquement pour l'année 2022 en ce moment et donc obtenir cela :

J'ai testé de mettre une condition d'affichage de la colonne grâce à une expression (year(Today())=Année mais cela s'applique aux 2 colonnes "VS N-1".

Je vous remercie de votre aide,

No

Hello Qlik Experts,

i have created some security rules, where users are allowed to develop in a specific developer stream.

The idea behind this is that there are not an unnecessarily infinite number of apps. And there is only one app, on which several users with certain rights work on the frontend/backend in parallel. I managed to make it so that certain users can open/read/edit the script editor. But in the frontend i am still missing two panels (fields, variable).

Is there any security rule that says, that users with the development property are allowed to see these panels?

Best regards Son

Hi all!

I don't know how to ask for new improvements, so I decided to write it down here.

Is it possible to add a new "table" on Outlook 365 Connector to mark as read a mail on O365 mailbox?

It would makes it easier for us to manage the receipt of data by mail.

Regards,

Alonso Torres

Hi All,

I have three different headers based on language and wanted to know how I can load this data in QV along with respective data for these three headers.

If you look at the sample below:

Row 1, 3, 5 are headers. Row 2,4,6 are respective data for these three headers. Now on the UI I want to create three report based on different header/language. Only identifier we have for three headers - LangaugeFlag. 

Sample Output:

Output 1: English

Output 2: Chinese

Output 3: Japanese

Please let me know how this can be achieved in the backend script. 

Note: have huge volume of data and loading the table from database. Only way to differentiate three headers based on Language Flag column

I have this graph in which the red bar represents the new products that have arrived, the blue bar represents the pending units (this are the units that have arrived and must be repaired) and the green bar represents the number of units that have been repaired.

I have used he following expressions:

New products: count({$<DateType={'Arrived'}>} ProductID )

Repaired: count({$<DateType={'Repaired'}>} ProductID )

Pending Units: rangesum(above(total count({$<DateType={'Arrived'}>} ProductID ),0,RowNo(total)))-rangesum(above(total count({$<DateType={'Repaired'}>} ProductID ),0,RowNo(total)))

This is showing my data correctly but when I select a particular date, the formulas apparently apply from that date and not for the total of the data.

For example when the date 31/03/2022 is selected the representation changes from the one seen above to the following:

How can I avoid this?

Hi all

I need to load multiple files into Qlik Sense from a Sharepoint library on our intranet. 

I've previously been able to load data from individual files by creating a direct connection to a file with no issues. However this time I need to load data from 100 different files in the same library so this method isn't viable. 

I do have access to the Office 365 Sharepoint Web Connector but haven't been able to get it to authenticate. Any tutorials on Web Connectors use a .com address as the base URL, but as I'm trying to connect to an intranet site it's a .aspx address which comes back as an invalid resource.

Does anyone have any advice? Thanks in advance

Adam

Hi,

Please help me with the below requirement.

Attaching the sample data and in the data we need to consider week '2244' .

Thanks,

Kishore

Hi

I have a couple of Qlik Sense Applications running on the windows server version that are failing to save when reloading (not all).

When I click the "Load Data" button in the Data load editor it seems to work fine until it gets to the end of the Data Load progress. the "Saving app..." appears for a brief second before it get overridden by the text "Unknown error".

Below is the contents on the Data load progress dialog on "Load data"

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

Hi, I want to see the count of dates that lie in current week.
I am using the expression 

=count({< [Date] = {">=$(=WeekStart(Today()))<=$(=WeekEnd(Today()))"}>}[Date])

but there is no output. 
Any suggestions on what am I doing wrong ?