transpose during load

[prees959]

Hi,

I have the following dataset in excel :

What I would like to do is during the load, calculate a total field. Also, where there are no values (eg, row 12) default to 1?

Is this possible?

Many thanks,

Phil

[Anil_Babu_Samineni]

Please share excel file

[sunny_talwar]

USER1 is 5? How?

May be this

If(RangeCount(CourseA, CourseB, CourseC, CourseD, CourseE, CourseF, CourseG) = 0, 1, RangeCount(CourseA, CourseB, CourseC, CourseD, CourseE, CourseF, CourseG))

[rwunderlich]

You'll want to start with a CrossTable load to unwrap the table.  Crosstable ‒ QlikView

-Rob