QlikView Developer Interview questions

[sharatqlik]

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

[shiveshsingh]

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

[ramasaisaksoft]

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.