I want to create a perfect format

[mithunr40]

Hello,

Client given me one report to create.

L2 Name	L1 Name	L1 Name	L1 Name	L1 Name
Lalit	Manjeet	Nitesh	Prashant	Rathijeet
	9	6	6	6
Raman	Yaman	Surjeet	Anand	Sunil
	6	5	7	4
Prashant	Ashish	Kuldeep	Sanjeev	Chirag
	5	3	4	3
Pankaj	Dheeraj	Shashi	Gaurav	Rajan
	3	5	1	2

I have created same report in pivot in qlikview but i am not getting same output.

L2_NAME	L1_NAME	Aman	Anirudh	Arun	Arvind	Ashish	Atul	Deepak	Dheeraj
Amit		-	-	10	-	-	-	-	-
Atul		-	-	-	-	-	3	-	-
Gopal		-	-	-	-	-	-	-	-
Lalit		4	-	-	-	-	-	-	-
Pankaj		-	-	-	-	-	-	-	3
Prashant		-	2	-	-	3	-	-	-
Sunil		-	-	-	7	-	-	8	-

Is there any solution.

Thank you so much.

[marcus_sommer]

Quite often you couldn't re-create a report 1:1 in Qlik - at least not in regard to an identically object structure and layout respectively not without a lot of efforts and more or less side-effects and which aren't seldom sensible.

More important are the information - and they could be displayed. Quite often with more possibilities and/or a better readability/usability as the origin report. Therefore my suggestion: don't try to replicate external (Excel) reports 1:1 in Qlik else adapting the strengths of Qlik to your data.

- Marcus