topic Re: How to make My Box 2 Display YrMthWk ? in QlikView

How to make My Box 2 Display YrMthWk ?

paulyeo11 — Tue, 15 Sep 2015 11:45:43 GMT

Hi All

I have and field name = Data Type at Box 1 :-

LOAD * INLINE [

Date Type, Column2

year,year

yr_jp,yr_jp

YrWk,YearWeek

YearQtr,YearQtr

YearHalf,YearHalf

Yr_Qtr_jp,Yr_Qtr_jp

YrMth,YearMonth

YrMthWk,YearMonthWeek

];

I have a Box 2 with below expression :-

=IF([Date Type]='year','Year',

IF([Date Type]='Yr','year',

IF([Date Type]='YrMth','Yr Mth',

IF([Date Type]='YearMonthWeek','YrMthWk',

IF([Date Type]='YearQtr','Yr Qtr'

)))))

My Question is why Box 2 not display YrMthWk ?

Paul

Re: How to make My Box 2 Display YrMthWk ?

Clever_Anjos — Tue, 15 Sep 2015 11:48:39 GMT

It would be easier if you post your app,

Try do this

=IF([Date Type]='year',[Year],

IF([Date Type]='Yr',[year],

IF([Date Type]='YrMth',[Yr Mth],

IF([Date Type]='YearMonthWeek',[YrMthWk],

IF([Date Type]='YearQtr',[Yr Qtr]

)))))

Re: How to make My Box 2 Display YrMthWk ?

paulyeo11 — Tue, 15 Sep 2015 11:48:41 GMT

Hi All

Enclosed My QV Doc

Re: How to make My Box 2 Display YrMthWk ?

Clever_Anjos — Tue, 15 Sep 2015 11:49:52 GMT

Re: How to make My Box 2 Display YrMthWk ?

Clever_Anjos — Tue, 15 Sep 2015 11:53:20 GMT

Try this

=IF([Date Type]='year',[Year],

IF([Date Type]='Yr',[year],

IF([Date Type]='YrMth',[YearMonth],

IF([Date Type]='YearMonthWeek',[YearMonthWeek],

IF([Date Type]='YearQtr',[YearQtr]

)))))

Re: How to make My Box 2 Display YrMthWk ?

paulyeo11 — Tue, 15 Sep 2015 12:30:51 GMT

Hi Clever

Thank you very much for your sharing.

I have try your propose script.

But it return wrong value.

I have enclosed my QV Doc.

Paul

Re: How to make My Box 2 Display YrMthWk ?

Clever_Anjos — Tue, 15 Sep 2015 17:05:34 GMT

it seems to be working here

Re: How to make My Box 2 Display YrMthWk ?

paulyeo11 — Tue, 15 Sep 2015 23:02:39 GMT

Hi Clever

What I want is make Box 2 display 4 field from Box 1 .

I manage to display 3 field at Box 2. But I am unable to make field YearMonthDay display at Box 2.

Paul

Sent from my iPhone

Re: How to make My Box 2 Display YrMthWk ?

Clever_Anjos — Wed, 16 Sep 2015 11:52:20 GMT

Please try this expression

=IF([Date Type]='year',[Year],

IF([Date Type]='Yr',[year],

IF([Date Type]='YrMth',[YearMonth],

IF([Date Type]='YearMonthWeek',[YearMonthWeek],

IF([Date Type]='YearQtr',[YearQtr],

IF([Date Type]='yr_jp',[yr_jp],$(=only([Date Type]))

))))))

Re: How to make My Box 2 Display YrMthWk ?

paulyeo11 — Wed, 16 Sep 2015 18:10:36 GMT

Hi Clever

Thank you for your reply. it still not get what i want. look like some thing wrong with my Doc. As some one also suggest the same script. also not work.

Paul

Re: How to make My Box 2 Display YrMthWk ?

MarcoWedel — Thu, 17 Sep 2015 21:20:41 GMT

Hi,

maybe this is what you need?

hope this helps

regards

Marco

Re: How to make My Box 2 Display YrMthWk ?

paulyeo11 — Fri, 18 Sep 2015 01:13:53 GMT

Hi Marco

Thank you for your sharing . May be my explaination is not clear , that is why so many people cannot understand. I hope below image can make all understand.