Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way to revert their location within settings, of via theme?
For usability this feels like a bit of a blunder, as if you have scrolling sheets, you now lose the arrows when you scroll.
On open :
Start scrolling ,lose the nav buttons for back/forward.
Dear Qlik developers,
I want to make a website that shows a visualization. I already tried to embed the visualization on a react.js app and it works wonderfully. However this approach makes user has to login twice (first to the website and one more login to Qlik)
What is the best approach to show a visualization on website without requiring user to login twice? Can I impersonate my user to access the visualization stored in Qlik? I have Qlik user with developer access and can generate API Keys
Thanks in advance for the answer
Dear All
The include variable is located behind the exit clause.
This script is not interrupted in the exit clause.
Why is the include variable executed?
*********** Script new *****
*************** Script end
Qlik Sense Version : Nov 2023 patch 7
Best Regard
Hanna.choi
Hi everyone,
i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.
So, consider having the following Table:
CreditorNr | Type | BankNr
010001 | 200 | 12345200
010001 | 200 | 12345200
010001 | 200 | 12345200
010001 | 200 | 12345100
010001 | 100 | 12345100
Using the following formula, i obtained the following MatchField:
=aggr(If(
Count(Distinct Type ) = 1 and
Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)
i get following results, that are also correct:
CreditorNr | Type | BankNr | MatchField
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345100 | Partner bank is not clear
010001 | 100 | 12345100 | Partner bank is not clear
Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:
TEMP:
NoConcatenate
Load CreditorNr,
If(Count(Distinct Type) = 1 and
Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
Resident BankTab
Group by CreditorNr, BankNr;
And i get the following result:
CreditorNr | Type | BankNr | MatchField | ScriptMatch
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345100 | Partner bank is not clear | Partner bank is clear
010001 | 200 | 12345100 | Partner bank is not clear | Partner bank is not clear
010001 | 100 | 12345100 | Partner bank is not clear | Partner bank is clear
010001 | 100 | 12345100 | Partner bank is not clear | Partner bank is not clear
So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear...
Can anyone please give me a hint on what im i doing wrong in the script?
Thank you for the support. 🙂
I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.
I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.
Load
count(if(status='Current',"EmpName")) as JanExisting,
count(if(status='Current',"EmpName"))
+count(if(status='New' and Month='Jan',"EmpName")) -
count(if(status='Exit' and Month='Jan',"EmpName"))
as JanFinal
Resident MyTable;
Load
JanFinal +
count(if(status='New' and Month='Feb', "EmpName", null())) -
count(if(status='Exit' and Month='Feb', "EmpName", null()))
as FebFinal
Resident MyTable;
Load
FebFinal +
count(if(status='New' and Month='Mar', "EmpName", null())) -
count(if(status='Exit' and Month='Mar', "EmpName", null()))
as MarFinal
Resident MyTable;
Hi,
I have a problem where I need to get Transaction data from a OLE DB data source and then add en Excel file with manually entered Budget data for four different companies, the load data look like this compressed with the relevant fields for two of the companies as below.
I add the company name as Client field for every company and the joined data for Transactions table is working as supposed.
My problem is that the budget data is added on the last day of the month because it's mainly relevant to look at this aggregated per month. But since there are multiple transactions in the Transaction data the last day of the month every month the Budget data get multiplied for every occurrence of that date.
What I've found is that I should use a Link table to solve this issue but it seems that my skills is not enough to get the script right.
I would like to group interval of accounts for example revenue, material cost, gross profit etc. for set analysis and add a master calendar (or similar) to do analysis on different time periods. Is it possible to have a Link table for Client, account and date fields and then add grouping and master calendar connected in the Link table or do you have to do this in the Load for the original data sources?
For a Qlik sense training course I have created a gauge displaying the ratio of males as a percentage of the total population. Because I wanted to have a benchmark, I set a limit which is dynamic with the use of a set-expression.
Whenever I select a different age group, the gauge changes to display a new number.
I have created a master item (measure) for this ratio and added this expression:
count(distinct(if(Gender='Male',PatientID)))
/
count(distinct(PatientID))
I don't know why but I thought of finding out a different way to write this expression. I tried some things and finally ended up with this:
count({1<Gender={'Male'}>} distinct(PatientID))
/
count(distinct(PatientID))
Can I conclude that both expressions actually do the same and performance-wise: does one way have an advantage over the other?
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
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!