Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting 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
Bonjour,
Je voudrais que mon utilisateur puisse filtrer soit par Catégorie, soit par métier
Dans un radiobutton, soit il coche "Catégorie", et seul le volet de filtre Catégorie s'affiche, soit il coche "Métier" et seul le volet de filtre "Métier" s'affiche.
Je précise que mes droits sont restreints, je ne peux pas écrire de script, ni créer de champs. Je peux juste créer des variables.
Hi Guys,
I want to how to filter max date from a field and when opening the dashboard it should get bookmark according to it.
=Num(InspectionDate2)=Num(Max(InspectionDate2)) I have tried this but it filters all dates but not pick max date.
Hello,
I have a dataset where only the city is available as location and I need to add the country to the datamodel. Do you have any suggestion how this can be done in Qlik Sense?
I have tried using the data manager and there I can create a geocode but it seems I can't generate the country as a separate field based on the city or the geocode. I know I can create a map and see the location country there but the requirement is to see the country information in a table.
Best Regards
Johan
Hello,
I use talend studio for esb without subscription. I would like to deploy my job in microservice.
The deployment tab cannot be modified. Is this because I'm only using a studio version?
Thanks
i have people names and then the city they belong to. However there is no country field.
Is QlikSense able to interpret the Country/Continent based off the City?
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 need to create a trend line with dimension [Year Month] interval YTD (jan to current month) and for each month i have to calculate the nine month before. I have already created thi graph with this measure:
Rangesum(above(count(Transaction),9)) and the formula works correctly if I don't apply any filter. The problem is that my dimension have to be a YTD so from January to current month but with this formulas January not include the nine month before.
How can i do?
Thanks a lot!
I've got some data from an external source where the Umlaut characters have been encoded as an A-like character. It's a real chore to identify the incorrect character in the data then find the correct unlaut, let alone doing the Replace. I cannot be sure I'm even identifying the correct match as it's a matter of deduction by working out what it should be. I'm wondering if there's a way to get Qilk to translate these or failing that a way of looking up individual characters online so I can build an table for a map.
i.e.
Character Replacement
Ãœ | Ü |
Ö | Ö |
Ń | Ń |
ß | ß |
Ó | Ó |
ÄŒ | Č |
É | É |
Ň | Ň |
Ř | Ř |
Äš | Ě |
Åž | Ș |
Ž | Ž |
Ź | Ź |
In Qlik Sense Enterprise, when a user clicked on an app icon it would open the app in a new tab. This has become the preferred option by many. In Qlik SaaS, the default when a user clicks on an app is to open the window in the same tab, unless they use the sub-menu of the app and select "Open in new tab". Is there a way to change the default option for all users or at least at the space-level?
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!