Keeping names when loading data

devans_1 — Wed, 11 Jan 2012 12:28:05 GMT

Does anybody know of a way of summing data and keeping the original fieldnames without having to use AS ? For example, if I have fields, 'Cost Price', 'Sale Price' and 'Tax', I am currenly saying

LOAD Sum ([Cost Price]) As "Cost Price",

Sum ([Sale Price]) As 'Sale Price',

Sum (Tax) As 'Tax'

It would be nice just to be able to issue the SUM without having to rename the fields back to what they originally were.

Keeping names when loading data

erichshiino — Wed, 11 Jan 2012 13:10:16 GMT

Hi, David.

I don't think it is possible.

The result would be the same in SQL or Oracle.

Maybe you could just load the data (without grouping it) and them use sum, avg, etc inside the interface.

This way the users would be able to explore the details.

Regards,

Erich

topic Keeping names when loading data in QlikView

Keeping names when loading data

Keeping names when loading data