Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb 88.9 and it is accumulating to 176% intead of feb 88.9 and march 89
This is my expression.
=rangesum(above(Count({<[NUMERATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))/rangesum(above(Count({<[DENOMINATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))
Hello everyone,
I am failing to understand what advantages could bring for me to implement NPrinting.
What is the difference in capabilities between NPrinting and QlikSense Story telling?
thanks in advance
Hello Qlik lovers, I have an interesting case that I came across and I hope you can help me solve it.
For this case, I am trying to filter against a numeric field [KPI_Code]
I created a Table and inserted [KPI_Code] as a Dimension.
I have 2 expressions, the results are in the table below
Expression A: Max(KPI_Code)
Expression B: Aggr(Only({<KPI_Code={"$(=Max(KPI_Code))"}>}KPI_Code),KPI_Code)
when I use a dollar sign expansion, it always gives me the maximum number in the dataset, disregarding the dimension value.
How can I use $() and still get values just like in Expression A ???
------------
Note: I need to use the $() because I need the output value inside a variable to call its expression
Example: vKPI_$()_Expression
if the $() resulted in 1001 then the variable would become vKPI_1001_Expression and I would use it's saved expression output in the cell beside its corresponding KPI_Code
KPI_Code | Expression A | Expression B |
1004 | 1004 | |
1001 | 1001 | - |
1002 | 1002 | - |
1003 | 1003 | - |
1004 | 1004 | 1004 |
The replication task is working, we change a column from NOT NULL -> NULL and the task gets suspended.
The task's DDL Handling policy says: "When source table is altered: ALTER target table"
At the moment, the tool is version 2022.11.0.208, we will upgrade it next week
Hi guys!
Following question because i think i go crazy.
I have a table with "reclamations" and this "reclamations" have different Date "Positions"
Some are notificated = we was informed that there is a problem, some are picked up from us from the customer, some are arrived our stock.
then there are timestamps when the customer is informed about costs and when for him its ok the date when gives us the ok.
start repair date, delivery etc.
All i want to have is a gantt with a timleine where i can mke this visible but i dont check it.
example for a line:
3 days from notification to pickup, 7 days from pickup to arrive our company, 15 days from inform the customer to his answer, 8 days for repair / production, 4 days from delivery stock to shippment.....
Has anybody an idea how i can solve this problem?
Thank you very much!
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. 🙂
Hi!
Simple question, we operate a production server and wanted to know if we can have a staging license. This will assist us to test some changes like moving to another domain and changing the admin user.
Thanks
hi all
trying to embed a sheet from Qlik Saas App into salesforce.
added Content Security Policy with the salesforce URL and I'm receiving an error message.
is anyone familiar with this error?
advance thanks
We are trying to update Qlik replicate ssl certificate..
In the installations steps we have app id ::{4dc3e181-e14b-4a21-b022-59fc669b0914} is this appid correct ??
How can i verify this app id is correct on my windows machine before updating the certificates without any issue running the below command
netsh http add sslcert ipport=0.0.0.0:443 certhash=<certificate thumbprint> appid={4dc3e181-e14b-4a21-b022-59fc669b0914}
hey !
Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it?
Additional details:
I want to be able to load the PDF file each time I use the app.
The PDF file contains both text and a data table.
I want to be able to work with the data in the app, such as creating visualizations and performing calculations.
Please provide any relevant documentation or tutorials that I can use to learn more about this process.
Thank you in advance for your help!
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!