Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

calculated Dimension help

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.

2 Replies
qliksus
Specialist II
Specialist II

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

arusanah
Creator II
Creator II
Author

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.