Discussion board where members can get started with QlikView.
how to load the attached excel file data.
what i am facing the problem is ,
after loading the data if i select Total1 and a data is coming for jan 14,but what i want is separate records like
total1 and a value should be 1
total2 and a value should be 13
If(WildMatch(Desc,'Total*'),Desc,peek(Total)) as Total,
(ooxml, embedded labels, table is Sheet1)