Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

same description in excel field

hi ,

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

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Try this:

LOAD Desc,

  If(WildMatch(Desc,'Total*'),Desc,peek(Total)) as Total,

     jan,

     feb,

     mar,

     apr

FROM

     [test123,xlsx]

     (ooxml, embedded labels, table is Sheet1)

     ;


talk is cheap, supply exceeds demand