Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kshitijas
New Contributor III

Null values in dimension

Hello,

I want AC BC as dimension but getting null values .

Here is the following code i have used and the result which m getting:

[Sheet1]:

LOAD

[Sr. No],

[Date of Receipt],

    Date(Date#([Date of Receipt], 'dd MMM yyyy hh:mm:ss:fff'), 'M/d/yyyy hh:mm:ss tt') as new_Date,

table1:

Load

[Sr. No],

[Date of Receipt],

    new_Date,

    month(new_Date) as new_month,

    Resident [Sheet1];

    Drop Table [Sheet1];


Table5:

Load*Inline

[new_month,Check

Jul,BC

Aug,BC

Sep,BC

Oct,BC

Nov,BC

Dec,AC

Jan,AC

Feb,AC

Mar,AC

Apr,AC];

image.png

Can anyone suggest whats going wrong ?

Thanks in advance!!

7 Replies
sureshqv
Esteemed Contributor III

Re: Null values in dimension

did u chk the filter  seperatly for   New_month?  are you getting values for that or not  ?

MVP
MVP

Re: Null values in dimension

Check in a list box how if your new_Date field coming left-aligned or right-aligned. If left-aligned; it is not parsed properly to get a date field and month() is not working on that. You have to look into your [Date of Receipt] field carefully and parse it properly using date#().

kshitijas
New Contributor III

Re: Null values in dimension

When i put list box for new_month,i get double months one in left align and other in right align. Can u suggest anyway?

Thanks!!

MVP
MVP

Re: Null values in dimension

What about new_Date field? Month field is association looks to be the issue. Try like:

Table5:

Load

     month( date#(new_month, 'MMM')) as new_Month,

     Check   

Inline

[new_month,Check

Jul,BC

Aug,BC

Sep,BC

Oct,BC

Nov,BC

Dec,AC

Jan,AC

Feb,AC

Mar,AC

Apr,AC];

kshitijas
New Contributor III

Re: Null values in dimension

if i take new_Date getting all values in right align .

MVP
MVP

Re: Null values in dimension

Try the solution I suggested above.

sureshqv
Esteemed Contributor III

Re: Null values in dimension

try this

month(Date#(field,'MMM'))  as  NewMonth