Date as column name

[#1]

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?

[sunny_talwar · Accepted solution]

Try using CrossTable Load: The Crosstable Load

HTH

Best,

Sunny

[#3]

Thank you.

[sunny_talwar]

No problem

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

Best,

Sunny

[Sarah_Miller]

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