i have data like this
how to load this data in qlik sense and and creating day wise calculation in qlik sense?
What are these columns (1, 2, 3) ?
This may help -
it does not look cross table to me maybe like this
crosstable (new1, new2)
from your source;
Retrieving data ...