Hello, I would like to use the “Chart Exploration” feature of the new version of the “Straight Table” object. It works very well, I just have a question: is it possible to
1) allow users to swap columns but not to remove dimensions / measures
2) otherwise, is there a simple way to retrieve the list of active dimensions? (my problem is that I have complex calculation functions with aggr requiring to know the list of dimensions used).

Best regards

Hi All,

Could someone please advise me on how to do the below mentioned one in Qlik sense .

- I have a table with 10 columns in that two columns (column1 , column 2 ) are having 10 categories each  and both columns are having same categories.
And there is one more column called sales   which contains sales numbers. Also, I have created a variable input drop down box which contains values like name, year, and location.
How can I create a table in Qlik sense with first column as drop-down box values and then horizontally two headers with Column 1 and Column 2 and then under that 10 categories and for each category how can I do summation of sales.

Thanks in advance 🙂

Hi,

I have a table with data.Employees and I want to display only all employees who have more than 10:00.

So I need the sum of datafield.az if the sum of datafield.az it is greater than 10:00 (hh:mm).

I can't use "if" because otherwise not only the dimensions of employees above 10:00 would stop, but also others.

Can you help me, please?

Hi everyone,

I'm trying to set up a writeback automation in Qlik Cloud that takes user selections and writes a comment to a separate data store (like a Google Sheet or SharePoint list). However, I'm encountering the following issue:

"The required inputs were not received."

Here's my current setup:

• I have input fields bound to variables (e.g. vComment, vID, ...) that populate correctly based on user selection. The variables are dynamically updated when a row is selected in a Qlik table.

• I created a button that triggers the automation. I enabled "Include selections" and "Execute in triggered mode."

• In the automation, I use a "Copy Inputs" block to receive the variable values.

• However, the automation fails immediately with the error above and shows no logs or steps executed.

What I’ve tried:

• Replacing dynamic expressions like =IDwith intermediary variables (vID2) and copying them into static ones (vID) using "Set Variable" actions before triggering the automation.

• Ensured the button is correctly configured to execute the automation and that my selections yield a single row.

Additional Information:

• Other automations (e.g. reloading apps) work fine.

• The app is published in Qlik Cloud.

• I'm following this video https://www.youtube.com/watch?v=hYER2nGKctM&ab_channel=Qlik and I'm getting the error half way when I try to update (around 9min30 sec in the video).
• Even with only these blocks, I get the error
  

   

   

Has anyone faced this before or knows how to fix the “required inputs not received” error when using dynamic variables and selections?

Thanks in advance! 

#Qlik Application Automation  

@AfeefaTk 
@PietMichielRappelet 

Hi all,

For the stop automation block how do you get the block to parse the value of the current RunID?  The automation ID is static as I would just use this automations' ID

Essentially I want the current automation to end when a condition is met but I'm having trouble getting this value.

Thanks

Bonjour, 

Je voudrais faire un set analysis qui me renvoi le nombre de vente réalisé par un opérateur depuis la dernière date possible.

J'ai fais ce set  " =Sum({$<[TRL-DATMVT]={'=$(max(TRL-DATMVT)-1)'}>}[TRL-QTEUV]) " et le résultat me renvoi 0.

Alors que je devrais avoir 179 

Pouvez-vous m'aider svp ?

I have ReadOnly access to MsSql database. I am not able to connect using Qlik MsSql connector because by default Qlik has "ReadWrite" as connect options.

Is it possible to change "ReadWrite" to "Read" option in data load editor or in QMC --> data connection?

I know I can ditch the Qlik MsSql connector and use ODBC connector and in Windows configure it by including "Application Intent" as "READONLY". But this would eventually result in our organisation using only windows ODBC drivers instead of any of the Qlik connectors.

I think "QvxConnectOptions" type is responsible for this Qlik default behavior. Is it advisable to change that file? do you know where I can find this file related to mssql connector?

If this is not possible, please let me know your opinion.