I have uploaded two files in Qlikview one is for price & another one is for some discount.
In both the table i have made crosstable.but date is coming as text .to convert it in date format i have used following expression
CROSSTABLE(Date, GP, 4)
Date#(Date,'DD.MM.YYYY') as Date1
FROM Billing_022016.xlsx (ooxml, embedded labels, table is Sheet1);
But getting some file not found error.