topic calculated Dimension help in QlikView

calculated Dimension help

arusanah — Tue, 19 Jul 2016 02:23:46 GMT

I am trying to create a calculated dimension to store post info from existing grp

. In my data set I have monthly record for each ID. When in grp field it hits ‘null’ it should store value (after null record) in new field.

e.g for ID =1 ,jan /feb/march has grp value A , and in April/may it has null. And in june/july it has B .. so it should store “B” in postGroup (calculated dimension). But some how I am not getting desired output. Can somebody help.

Re: calculated Dimension help

qliksus — Tue, 19 Jul 2016 08:13:41 GMT

Can you elaborate more on the what is the expected O/P ?

Re: calculated Dimension help

arusanah — Tue, 19 Jul 2016 13:17:15 GMT

I am trying create a new group INFO column for a person when I find a null value for a GRP field for him . if you take a close look at excel I sent ,

For ID = 1 ,jan /feb/march has grp value A , and in April/may it has null. And in june/july it has B .. so in new grp which in my case POSTGRP it should store “B” for the said recipient.