topic Re: QlikView Developer Interview questions in QlikView

QlikView Developer Interview questions

sharatqlik — Fri, 22 Feb 2019 06:42:26 GMT

employee table available in data model clint wants department wise total salaryto be visualized the depatment and employee name provide in the separete excel file which is most optimized approch lo link salrary with department in qlikview

Re: QlikView Developer Interview questions

shiveshsingh — Fri, 22 Feb 2019 07:26:00 GMT

May be you can do a left join on Employee_ID from one fact table to the excel file.

Re: QlikView Developer Interview questions

ramasaisaksoft — Fri, 22 Feb 2019 09:12:56 GMT

Hi Sharat,

as i know creating a "Pivot table" is the best approach.

Dimensions we need to took like below

Dept,Employee,Sum(Salary)

go to properties of the Pivot table ,select the option subtotals for Dept dimension so that it will create Department wise salaries.

Sol 2:-

"Emp" and "Dept" Tables are associated with "Emp ID" always ,so no need for any join condition.

Note:-between those tables automatically Full outer join will create when Association is available.

correct me if i wrong understood your query. else close the thread.