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

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! 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!!!