This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have data (from Excel) that looks a bit like:
This has been loaded as part of about 75 other columns like this:
Note that the venue name is actually loaded elsewhere in the script so what I want is the have just the budget for each MonthYear and Venue loaded as a single field.
I've been looking at doing a crosstable load resident from the main table but can't see quite how to use the syntax to create just a budget field for each MonthYear and Venue:
Any ideas about how I can achieve this?Thank you for all previous helps.
Below is example which will work regardless of the number of columns you enter, you just need to list them in the first Load statement (keep in mind the MonthYear should come first).
Here is the template script you can use:
Data_temp:CrossTable(Venue, Budget ,1)LOAD * INLINE [MonthYear, VenABud, VenBBud, VenCBud, VenDBud, VenEBudMay-19, 495, 259, 430, 250, 150Jun-19, 495, 280, 400, 200, 125Jul-19, 495, 295, 350, 280, 100];
Data:NoConcatenateLOADMonthYear,Mid(Venue,4,1) as Venue,BudgetRESIDENT Data_temp;
DROP TABLE Data_temp;
I hope that helps!
View solution in original post
solved here :
Thank you S.T.
That worked perfectly. I just had trouble interpreting some of the other posts on the subject to fit my scenario.
All sorted now.