Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a table I set a Filter Pane and a Table with columns.
Rather than select manually the items from the Filter Pane, I would like to filter the items through an expression similar to this:
=only({<[Material Number (Product)]={
'xyz'
}>}
[Material Number (Product)]).
Probably the expression is not adeguate to the Filter Pane.
Is there any way to filter it by a predefined list?
Thanks
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
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!