Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
What are these columns (1, 2, 3) ?
it does not look cross table to me maybe like this
crosstable (new1, new2)
LOAD *
from your source;