I created a visual with the columns transport zone and departure day.
These two columns both come from a different table but are linked by a field that exists in both tables.
I have a third table where each transport zone has the departure time. It may be that a transport zone has multiple departure days and therefore the transport zone must be matched with the departure day to get the correct departure time from the third table.
Does anyone have an idea how I can set this up in Qlik?
Thanks in advance for thinking with me.
I have a table with data based on the employee's work date (WorkYear, WorkMonth). If there are employees who separated, I need to count them by their TermDate, but the Year and Month of the TermDate should equal the WorkYear and WorkMonth to get an accurate count by WorkYear and WorkMonth. I tried the following set expression but it doesn't work. Any suggestions?
aggr(sum({<WorkYear={"=Year(TermDate)"},WorkMonth={"=Month(TermDate)"}>}Separated),WorkYear,WorkMonth,HomeBusUnit)
How do I set the default value in a multi-select filter. Example: Filter Country has 30 countries but when you first load the app, you have it set to Canada, US, Mexico and that is what shows in the label inside the dropdown.
Country
US, Mexico, Canada |
Bookmarks is not something I am looking for!
My Line Chart and scatter plot is very slow, How to improve those visuals performance. Iam attaching my qvf file,
I have very less time. Immediate help is appreciated.
Hi,
I have found multiple posts for this but none have worked.
I'm trying to create an action button for multiple values of a field. It works fine for 1 value from the list below, but I cannot seem to get the syntax right for all 2 field values below.
Action=set values in a field
field = ID
value = '3Z' (this works okay - for any single value from below)
bit I need all 2 below included??
value = '3Z' and '60'
(I have tried with quotes, with ";" and without, pipe separators...etc...)
Thanks by advance,
Hi! Has anyone had any issues creating a NPrint report and all the dashboard inserted on the template come out looking too wide or on 2 pages? I’ve played with resolution settings, but no luck. Any guidance would be helpful! ty
Pessoal, Bom dia Dia. Tenho os campos, Qtd vendida, Tipo da venda(Fracionada,normal,multipla e Hibrida) e produto. quero fazer 4 KPIS onde o titulo seria "Produto mais vendido Fracionado" ai dentro do kpi ficaria o produto com maior qtd de venda do tipo fracionado estou usando a extensão simpleKPI.
Hello,
I am a beginner in Qliksense and I have a question on the use of set analysis.
My data are formatted like this : [Date] , [ID], [Contract], [availability], it is a database that record everyday if employees are available and what is their contract (CDD, CDI)
I would like to compare two different dates in order to know how many employees are CDI and how many are CDD
I have 2 dates picker with 2 differents alternatives states : Date1 and Date2
I don't manage to have the correct KPI corresponding to the selected date.
My expression is : =Count({<Contract={'CDI'}>}Distinct ID)
And this KPI is affected by Alternative State "Date1"
Could you please help me ?
Hi All,
Scenario is like I want all the "sales score" values in customer table and if the "sales score" is null it should pick pervious date "sales score" value without null. Here it should be order by CustomerID and Date.
E.g.
Can anyone help me out here to achieve this.
Thanks in advance!!!
Qlik Staige, an all-encompassing solution that provides the technology, ecosystem, and expertise you need to bring better insights to your business, faster.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on Sept. 27th at 10 AM ET for the next Do More with Qlik session, where we will be featuring Insight Advisor – our intelligent AI-assistant in Qlik Sense.
Real-time Responses Delight Burgan Bank's Customers.
Alaska’s Northrim Bank wins the SBA Lender of the Year award, using Qlik to target unique local needs.
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!