Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I need to create a filter in the set analyses which sums only the records where the #eventDate is in the first 8 days after the #installDate. Both dates are stored as numbers (eg: 47823)
The below formula works fine when the two dimensions are selected in the table, however since this is a dynamic visualization, i need to incorporate the if statement in the Set analysis so it always filters the results regardless of the selected dimensions in the table.
if(eventDate <= date([installDate.date.Date] +7), Aggr($(vL.exp.KPIs.Period(Sum,$(=Only({<#meCode={"msr46"}>} [#kpi_id])),appstore*,appstore*, )), $(vL.selected.Dimensions.field)), 0)
I have tried numerous options in the set analyses however nothing seems to work.
Ex:
$(vL.exp.KPIs.Period(Sum,$(=Only({<#meCode={"msr46"}>} [#kpi_id])),appstore*,appstore*,, eventDate,<=[installDate.date.Date]+7))
The formula for vL.exp.KPIs.Period is:
$1({<KPI={"$2"},Source={"$3"} $(vL.time.Period), [$6]*={"$7"}, [$8]*={"$9"}>} $5 (KPI.Multiplier/KPI.Denominator)*value*Nume_multiplier)/If($1({<KPI={"$2"}, Source={"$4"} $(vL.time.Period), [$6]*={"$7"}, [$8]*={"$9"}>} $5 value*Denome_multiplier)=0,1,$1({<KPI={"$2"}, Source={"$4"} $(vL.time.Period), [$6]*={"$7"}, [$8]*={"$9"}>} $5 value*Denome_multiplier))
Any ideas will be appreciated!
Hi All,
I have attached a sample dataset (Ledger Account), in which I have highlighted a column in yellow, which is the column to be achieved in Qlik Sense.
Can anyone refer to that, give me a solution. I have attached below a screenshot also.
What Should Happen -> In the balance column, we have the amount of each document value, In a new column, first line should show (Closing balance of 2023-balance column first line doc value), and in second line it should show, (new column first line value-balance column second line doc value), and it should till last row.
Note: - This is only one ledger account dataset, there are multiple ledges.
Hi All,
I have created a default bookmark selections for all sheets. I'm selecting few extra selection in a sheet with default bookmark and switching to another sheets. Post switching to another sheet i'm only able to see the default bookmark not the extra selections with it.
I want to carry the extra selections with default bookmark when i switching the sheets within the application.
Thank you in advance!
Daya
I have a variable set as vCurrentMonth showing 19 which is the Date.Chron.Month value.
I would like a textbox to display the value for Date.Month.Year (May-2024) through using the vCurrentMonth variable.
Does anyone have any suggestions on how this may be done?
Thanks in advance!
Date.Chron.Month | Date.Period | Date.Month.Long | Date.Month.Short | Date.Year | Date.Month.Year |
19 | 7 | May | May | 2024 | May-2024 |
Hallo,
ich habe eine Button gemacht, mit dem ich die Daten neu laden kann. Grundsätzlich funktioniert das, aber nur mit meinem User (Professional Access) als Analyzer funktioniert der Button nicht, weil es dazu keine Rechte für diesen User gibt.
Kann das irgendwo eingestellt werden, dass ein bestimmter User dieses Recht zum aktualisieren bekommt ? natürlich nur über diesen Button und nicht generell.
anke
LG
Martin
I have a dimension that I created called Proposed Bucket.
Here is my if statement:
I want to create a measure that adds up certain elements of this proposed bucket.
Hello,
I have a set of data which contains dates reaching from 01-03-2024 to 30-03-2024 and various dates in 2023.
Now I need to get the first date out of my data set but out if this year. This would be 01-03-2024.
When I use min(), minstring(), makedate() the result is either 01-01-2024 or the first date in the data which is some day in 2023.
Is it possible somehow to get the desired 01-03-2024?
Hello,
I have a issue with these data, i need to create Cumple? field, the rules is with the same id_vehiculo, with different CodTransito and PuntoCobro, the difference between fechahora(1) and fechahora(2) is <= 20 minutes
How can i do these?
CodTransito | ID Vehiculo | PuntoCobro | FechaHora | Cumple? |
20056995 | V2 | 201 | 11-03-2024 08:57:14 | No |
20063584 | V2 | 101 | 11-03-2024 12:23:42 | No |
20072249 | V2 | 201 | 11-03-2024 16:33:01 | Yes |
20072418 | V2 | 101 | 11-03-2024 16:37:43 | Yes |
20092881 | V2 | 201 | 12-03-2024 09:55:24 | No |
20099617 | V2 | 101 | 12-03-2024 13:30:57 | No |
20110838 | V2 | 201 | 12-03-2024 18:42:12 | Sí |
20110960 | V2 | 101 | 12-03-2024 18:46:33 | Sí |
Hello,
Is it possible to do cell sorting by color in qlikView?
I have such data and I would like to sort in such a way that records must be colored first.
Please help!!!
Hi,
In the example of getting the impersonation access token data-get-access-token is associated with the function that fetches the access token.
If I already have the access token because I fetched it earlier, how would I format it so that it fits the variable or if I have to, set it in the function getAccessToken()?
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
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!