Need Answers for few scenarios

Jay587 — Mon, 06 Jan 2025 06:22:03 GMT

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.

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 ?

What is the output result table in Qlik ?

Thanks.

Re: Need Answers for few scenarios

PradeepK — Mon, 06 Jan 2025 06:31:32 GMT

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