topic Which sheet object should I use? in QlikView

Which sheet object should I use?

Tue, 17 Jan 2012 19:44:35 GMT

Hi, I'm experimenting with QlkView object and trying to decide which one to use for this type of table. I will need calculate the values of several of these columns. Thank you. Jim

month_date

balance

roll off

roll off wac

roll on

roll on wac

ending balance

Which sheet object should I use?

erichshiino — Tue, 17 Jan 2012 20:25:01 GMT

Hi, JFrancisco.

You should use a straight table. Eventually, a pivot table. It will depend on your data, if you want to let the user dinamically sort the columns (only available for straight table), etc

Hope this helps,

Erich

Which sheet object should I use?

Tue, 17 Jan 2012 21:15:48 GMT

Thanks Erich! yes I've moved on to a pivot table. I've created a field in my load statement "RollOnOff" which will allow me to sum up bals rolling off and bals rolling on. However, when I put it in my pivot table, it only shows what's rolling off and on if I pick one or the other.