Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a column in my data with what looks like timestamps in, but I'm struggling to convert these into meaningful date times in the load editor. The data before the . is always 5 digits long but after the . there's a mixture of different length values - Could this be causing the issue?
Some sample values include...
45208.389583333
45208.41875
45208.640972222
45205.33125
45205.5
45205.448611111
If I add a duplicate column in the chart table with Timestamp(FIELD_NAME) the value converts correctly but if I try to do this in the load editor the value always stays as the timestamp value.
Am I doing something wrong?
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'm using Qlik Sense May 2024 Version. I need to access the Office 365 SharePoint from Qlik Sense.
Kindly suggest how to create connections, what could be the Base URL and Prompt/Consent level etc.
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.
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!
hello,
I have requirement to show previous 3 months data excluding current month in table chart month-year as dimension.
i am using below set expression
=Sum({1<DATE={">=$(=MonthStart(AddMonths(Max(DATE),-3)))<=$(=MonthEnd(AddMonths(Max(DATE),-1)))"}>}[SUBS_GROSS_ADD])
it is working for text object respective of selection.but in table chart i have four aggregation fields based on moth-year dimension and only for one aggregation i have to show previous 3 months excluding current month so i am using above set expression for that but it is not working.it is giving month wise aggregation instead of previous 3 months results.how can i achieve this in table chart with dimension.
please help on same.
Thanks in advance.
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.
Workshops. Certifications. And Disney's Animal Kingdom® Theme Park. Only at Qlik Connect. May 13 - 15.
Optimize your data strategy with Iceberg lakehouse insights, cost-saving tips, and a preview of Qlik Talend Cloud’s no-code integration.
Data Flow simplifies, democratizes, and accelerates the last mile of data preparation for analytics, machine learning, and AI.
Read how to embed AI-powered analytics to innovate, enhance customer satisfaction, and fuel business growth.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.
Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!