Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator II
‎2017-10-18 12:20 PM

transpose during load

Hi,

I have the following dataset in excel :

sense_transpose.PNG

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

Labels (1)
Labels
1,074 Views
0 Likes
3 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-10-18 12:24 PM

Please share excel file

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
967 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-10-18 12:24 PM

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))

967 Views
0 Likes
rwunderlich
MVP
MVP
‎2017-10-18 12:27 PM

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

-Rob

967 Views