Need Answers for few scenarios

[Jay587]

Hi Team,

I have few scenarios and need answers for below one's.

Thanks in advance.

1.Write an expression to find the number of days between 2 dates DATE_1 & DATE_2 ? Format = DD/MM/YYYY

dates are 12-Dec-2024(DATE_1) to 15-Dec-2024( DATE_2) ?

2.Below is the input table and need the output table in Qlik as mentioned that one as below.

Input Table
EMPLOYEE:
EMP_ID	DEPARTMENT	SALARY
1	X	4000
2	X	5000
3	Y	2000
4	Y	4300

Output Table
DEPARTMENT	Highest_Salary
X	5000
Y	4300

3.What is the result for the below scenario ,How the data model looks like whether it is one table will appear in data model or two tables ?

Table_1:
Load A from Table1.qvd(QVD);
Table_2:
Load A from Table2.qvd(QVD);
Expected Data Model -
Table_1		Table_2
A	------------	A

What is the output result table in Qlik ?

Thanks.

[PradeepK]

1- Fabs ( Date#('12-Dec-2024','DD-MMM-YYYY') - Date#('15-Dec-2024','DD-MMM-YYYY') )

2- Create a straight table, Add Dimension - Department and Measure - max(SALARY)

3- Only One table <Table1> due to Auto concatenation