topic Re: Date as column name in QlikView

Date as column name

Wed, 12 Aug 2015 02:41:43 GMT

I've got a table with multiple date columns with data rows. Ex : Jan-2015, Feb-2015, Mar-2015 etc... But when I calculate sum of these columns' data, it counts column title itself. QlikView counts Jan-2015 as 42005 and sums it up.

Any idea to get correct result?

Re: Date as column name

sunny_talwar — Wed, 12 Aug 2015 06:19:56 GMT

Try using CrossTable Load: The Crosstable Load

HTH

Best,

Sunny

Re: Date as column name

Wed, 12 Aug 2015 07:45:00 GMT

Thank you.

Re: Date as column name

sunny_talwar — Wed, 12 Aug 2015 07:46:48 GMT

No problem

I am glad I was able to guide you in the right direction.

Best,

Sunny

Re: Date as column name

Sarah_Miller — Thu, 13 Aug 2015 15:18:46 GMT

Greetings

Thanks for your post in Qlik Community. Your question has been moved to the App Development sub community. Based on the content of your post I think it will be visible to more members in the new location.

The Education group is only for questions related to training, certification, and any programs we offer.

Thank you,

Sarah Miller