Hello.  I'm sorry as I'm sure this question is asked a lot but I wanted to get everyone's opinion on the best way to learn Qlik Sense. Here are the questions I have:

1) Data Transformations - I'm used to performing data transformations using Power Query which visualizes the data and has a drag and drop interface.  From my limited research, it looks like Qlik uses a scripting language to transform data prior to integrating it into a data model.  This seems like it will require a good amount of time to learn.  Is it better to spend that time learning the QLIK Scripting language or should I just learn how to do it in SQL and then bring in the data?  I am sure there are pros and cons to both but in the short-term I'm probably only going to bother learning one and I wanted to know what is preferred among Qlik Users?

2) Training - What courses have people used to learn Qlik Sense?  Are there known youtubers?  I saw Qlik Sense has a free business analyst video set.  I watched a few introduction videos and most of it is pretty intuitive.  

The two areas I'm struggle with is understanding how filtering works in Qlik Sense but I think I just need more practice playing with data.  The big area of focus is to understand the lexicon (what functions are available in Qlik Sense, how they work) and the syntax in Qlik Sense so I can write functions/play around with it.   

Thank you for your time!  

Hi ,

Can you give some example how to gives access group level qlik sense section access.

I have some requirement like below:

let's we have Total 6 user: They are divided into 2 Group.

How to Give access 2 group different level country access.

ex: 1st group need IND,USA access 

     2nd  group need UK,AUS access

I have provided the Data below

Sales:
Load * inline

[

Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300

2019, USA, 120
2020, USA, 220
2021, USA, 500

2019, UK, 350
2020, UK, 650
2021, UK, 150

2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];

Hi Team,

Can we replicate structure? 

we are already replicating pool tables from SAP System but when we connected with SAP team for replicating KAEP_COAC table. they denied it saying it is not pool table. it is a structure. they cannot add in business user group like they do for pool table.

Thanks

Amit

Hello everyone, i'm having issues trying to create a canonical date in qlik sense when associating tables and was wondering if anyone would be able to help out. In basic terms i have 2 tables: "orders" and "sales rep visits", which are associated to the "customer data" table by customer number, (very simplified) script below:

Hi Experts,

I have a loop automation that runs continuously until the timeout of 14400 seconds.

The automation fails few seconds before the 4 hours limit, so when the schedule time arrives it should be executed again.

The problem is that the automation skips some executions during the day without any errors or log file.

Is this a bug?

Best Regards,

Michela

Hi team,

I have filter, In that i have some values.

Eg:

A

B

C

D

if I select A and B its to display sum(Sales)

If I select A and B and C etc its to display count(Sales)

For Particular Selection, I need to show one measure,

If extra anyone Value is added in the filter it should show other measure...

Thanks in Advance

TLDR : I want to access an Excel file based on a sharepoint path I give manually.

What I've tried : you can give to a "Open file on Microsoft Sharepoint" component a path directly linking to a document, and then use a "Read Data From File on MS" to open it but it only works for CSV and JSON documents. 

You can also acces the document based on a Drive ID and Item ID with a "List Rows With Headers" for example. This solution however needs me to access every item of the file tree until i get to the file containing the excel wich is not really sustainable. 

So I would need a component that either open an xlsx document based on a path or give a Drive ID and Item ID based on a path.

Any other idea would help.

Thanks in advance,

Maxim Perolle

Hi Team,

We are getting below error in a task.

Could you please help us with the same.

SYS-E-HTTPFAIL, Cannot connect to sql server.
SYS,General_Exception,Cannot connect to sql server , sqlstate:08001 NativeError:-2146893016 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The received certificate has expired.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot coonect to SQL Serv
RetCode: SQL_ERRO SqlState:08001 NativeError:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider:The target principal name is incorrect.

Regards

Mrunal