Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am trying to connect to a FTP and download (tFTPGet) excel files after having them listed (tFTPFileList and iterate on them)
Those files can have the extension .XLSX or .xlsx (i.e. the extension in UPPERCASE or lowercase)
In the files section, "File Mask", if I only allow "*.xlsx", I won't get the .XLSX files and vice versa
If I set both "*.xlsx" and "*.XLSX", I have the afterwards treatment run twice.
I may also get the error in the tFileInputExcel afterwards : "
Do you know how to properly open the two variations of the Excel files ?
I currently download everything (File Mask "*.*") and the add the .xlsx extension (I will then have a file.xlsx.xlsx) which is not a good solution.
Hello,
We're seeing a strange situation with our Section Access that we've never seen before.
We have a Subjects table in our database with a field (SubjID) who's data type is (PK, int, not null). The values are straight forward. For example:
SubjID | Name |
1 | Bob Smith |
2 | Jim Longley |
3 | Sarah Whitely |
Our section access query is:
SQL select 'USER' as "ACCESS", upper('MYDOMAIN\MYUSERID') as "USERID", '*' as "GROUP", null as "OMIT", SubjID as "Subject" from Subjects;
Our application body has the following query:
[Subjects]:
SQL select SubjID as Subject, Name from Subjects;
The above does not work; the table is read but I get no access to the data. However, if I change the above query to the following:
[Subjects]:
Load *, num(SubjID,'0') as Subject;
SQL select SubjID, Name from Subjects;
The above does work. Any idea why the internal representation of the Subject field in the Section Access query would differ from the representation of the same field in the [Subjects] table, such that section access works in one case but not the other?
Thanks,
Steven
Hello,
how to declare a script variable, which value depend from a value from a selection in a sheet Object and then I load the script new.
your Help will be so welcome.
thanks in advance
Frédéric
Hi Community,
I have given below data set:
Date | Periods | Franchise | Country | Orders_Numbers |
01.01.2022 | 1 | Burger | USA | 101 |
01.01.2022 | 2 | Burger | Canada | 101 |
01.01.2022 | 3 | Burger | Australia | 101 |
01.01.2022 | 4 | Burger | France | 102 |
01.01.2022 | 5 | Burger | Spain | 102 |
01.01.2022 | 6 | Burger | Italy | 102 |
If I write Expression in the GUI: Count(DISTINCT Orders_Numbers) then I'll get 1 for the Orders_Numbers = 101 whenver I'll select / deselect any dimension on the GUI. If I'll clear all the dimensions then I'll get 2. One for each Orders_Numbers due to Count(DISTINCT Order_Numbers).
I want to achieve the same results using Edit Script. How to do it ? I don't want to remove any dimension Filter from the GUI.
I tried this solutions to achieve the same results but the problem is I got 3 for the Orders_Numbers = 101. Becaue the %Key has a unique Periods in the %Key that makes it unique while I count on the GUI then it returns me the 3 not one due to the %Key. If I write DISTINCT in the Expression then I'll always get 1 for all the data set.
Do I need to change the expression after the below load edit script or what is the right way to do it ?
Hi All, I have a requirement in Qliksense straight table. We have created 12 calculated dimension in front end. We want to transpose it to display the values in single Column. Can someone please help how to transpose it in front end ?
Qlik Compose for Data Warehouses
Hello everyone,
in qlik sense
I have a timestamp in a string format and I need to convert it into a date and time with e specific format.
the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string
This is the sheet that I created in Tableau. How can I replicate it in QlikView? The values are the sum of sales (in the block). I have tried creating a pivot table, but I can't get months as columns; all months are in one column instead of different columns. Thanks in advance.
Hello,
I'm using an InputBox to use the variable in the script, but the variable in the Input Box is defined with an function expression as 'Num(GetFieldSelections(X))' and then in the script Qlik use the text of the function and not the value of the function.
What must I do, to have only a value
Hi,
I'm trying to connect a Project that I'm authorized to only view it on Bigquery to the Qliksense. I tried to create a service account for this project on bigquery but couldn't and I think it's because I have permission to only view the project. Have anyone tried doing the same before? Do I need to take a different approach other than using OAuth Mechanism? Any help would be really appreciated.
Hi there!
How does NPrinting work, if a user is assigned to more than one Security Rule? Do the permissions "add up"?
I'm trying to work out a setup where I can split what NPrinting users can do and what data they have access to. I have some "Data"-roles where each role has access to different apps in the Selected items-section. Also, I have some "Role"-roles that define what the user can do, i.e., roles for a developer, a tester an end user and so forth.
The general idea is, that I have different developers that should be able to do the same stuff: work with reports and tasks. But each developer might work with different data. So, a user always has two roles: one for what data they can see (apps) and one that decides what they can do (create new, edit, delete, view etc.).
I have an admin-role too that sets up the apps and connections as a prerequisite for the above.
Only it doesn't work as I would expect! On the "Role"-roles there is no access to apps, this access is on the "Data"-role. But it is the role with the app permission, that decides what can be done - without an app in Selected items, nothing can be done, no new app can be created and so on.
But if I add the developer's permissions on the "Data"-role where the app resides, then the end user can do the same as the developer. And that was not the intention...
Hoping someone has tried something similar!
Best regards
Simon
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
Get to know these Qlik experts driving innovation and excellence in data, analytics and AI.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!