Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
Enclosed My QV Doc
Further reading QlikView Quoteology
Try this
IF([Date Type]='YrMth',[YearMonth],
IF([Date Type]='YearMonthWeek',[YearMonthWeek],
IF([Date Type]='YearQtr',[YearQtr]
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.
it seems to be working here
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.
Sent from my iPhone
Please try this expression
IF([Date Type]='YearQtr',[YearQtr],
IF([Date Type]='yr_jp',[yr_jp],$(=only([Date Type]))
))))))
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.
