Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi.
Is it possible to loop through all the sheets in a QS SAAS app, export it as an image and then send via teams?
I can only see an option for PDFs but it would be nice to have it sent as an image instead.
Many thanks
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
Join Qlik's office-hours, recorded live, where our experts help you with your dashboard, app, and visualization related questions. This month's topic is: App Development.
Questions:
Resources:
Did we answer your question? Let us know by clicking the like button!
Click here to see video transcript
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;
Hello everyone !
I have lately learned how to use Talend ESB and I'm able to implement a REST API.
However, it uses HTTP procotole. Is there any tutorial explaining how to activate and use HTTPS ?
Is there the same concerning token and OAUTH activation ?
Thank you !
Hello QS experts,
I am dealing with a bar chart. Here is the outcome when I only select March 2024.
I'd like to add an Alternative Dimension, which is the autocalendar.YearMonth.
After adding the dimension, it seems that it couldn't fit with my current measure expression.
The accumulation should be 359, but it shows 16 instead.
Is there any way add another expression to fit with the dynamic dimension?
The expressions I am using are:
Measure:
=
Aggr(
Count({<Date={"<=$(=Today())"} >} ID),
Class , (Date,NUMERIC,ASCENDING)
)
Dimension:
Date, Class
Mapping Load / Apply Map was functionality which was shown to us during our initial training session with QlikTech many moons ago but it is not something that I have used within my scripts instead using left joins to get say description of a code into my QVD table.
Not really sure what the benefits or differences are between using mapping and left joins and would be grateful if someone could elaborate on this for me...
Many Thanks
Buongiorno,
avrei bisogno di creare un valore nuovo relativo ad una dimensione già esistente, unendo due valori relativi alla suddetta dimensione. Ad esempio tra gli agenti ho l'agente 'Caio' e l'agente 'Sempronio' che devono essere aggregati nel nuovo agente 'Caio + Sempronio'.
C'è possibilità di creare tipo un oggetto di transcodifica?
Grazie
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!