Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please share excel file
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))
You'll want to start with a CrossTable load to unwrap the table. Crosstable ‒ QlikView
-Rob