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 the file format as below
How can I group this to year ? In the Raw file I have columns from Q415 Seats to Q430 Seats (2015 - 2030)
How about this:
CrossTable (Qtr, Seats)
(html, codepage is 1252, embedded labels, table is @1);
2000 + mid(Qtr,3,2) as Year,
Sum(Seats) as Seats
Group By Code, 2000 + mid(Qtr,3,2)
DROP TABLE Raw;
View solution in original post
try to use rename function to change them to Months(or years ..) first
the following link may be usefull..
Hi Ansh, since you are trying to rename fields performing a calculation based on the old name i would go with the rename script function. This way you can use a dinamic renaming based on a table you can easily mantain from excel or an inline.
Rename field ‒ QlikView
Hope this helps.
Thanks much Rob