Cross table

[stephenedberkg]

i have data like this

	Feb-18		1			2			3
Emp ID	Name	Department	Hrs	Amt	Reason	Hrs	Amt	Reason	Hrs	Amt	Reason
1	AA	IT	2	50	asd	23	54	yu	23	54	yu
2	BB	CSE	3	34	fcd	45	56	hh	45	56	hh
3	CC	CSE	5	56	qwe	67	6	hh	67	6	hh

how to load this data in qlik sense and and creating day wise calculation in qlik sense?

[YoussefBelloum]

Hi,

What are these columns (1, 2, 3) ?

[Digvijay_Singh]

This may help -

https://community.qlik.com/docs/DOC-4527?et=watches.email.document_comment#comment-65534

[zebhashmi]

it does not look cross table to me maybe like this

crosstable (new1, new2)

LOAD *

from your source;