Display name

[soniasweety]

Hi all,

i  have date field in the table 

but i want to show the  dimension like below

PFA.

day1 day2 day3

how can i get like this?

can anyone help??

[qlikviewwizard]

Upload some sample data.

[tresesco]

Try calculated dimension like:

='Day ' & Day(Date)

[soniasweety]

but it is showing  by default day21 day22 day23 based on my date field

but i want fixed     i tried below but its not working

=if(DateName='Mon','Day1',

if(DateName='Tue','Day2',

if(DateName='Wed','Day3',

if(DateName='Thu','Day4',

if(DateName='Fri','Day5',

if(DateName='Sat','Day6',DateName))))))

[tresesco]

Use weekday() like:

='Day' & Num(WeekDay(Date))

[soniasweety]

thanks

but  i want to exclude the sunday in the dimension  and  day1 to day6 i need now i am getting day0 to

tried this

='Day' &if(WeekDayName<>'Sun', Num(WeekDay(DateName)))

[tresesco]

Try putting the if condition first, like:

=if(WeekDayName<>'Sun', 'Day' & Num(WeekDay(DateName)))

[qlikviewwizard]

='Day' &if(WeekDay(DATE)<>'Sun',Num(WeekDay(DATE))+1)

[MarcoWedel]

Hi,

one solution might be:

table1:
LOAD *,
    WeekDay(Date) as WeekDay,
    'Day'&(WeekDay(Date)+1) as Day,
    Ceil(Rand()*100) as Value;
LOAD Date(YearStart(Today())+RecNo()-1) as Date
AutoGenerate DayNumberOfYear(Today());

hope this helps

regards

Marco